SQL server

About this task

Run the following ALTER DATABASE commands to create filegroups that are used for the ODF system tables when using SQL Server.

Procedure

  1. Modify the sample ALTER DATABASE command to create the filegroups listed. The ALTER DATABASE command must be run multiple times, once for each of the filegroup names. The example shows the ALTER DATABASE command for the first filegroup in the list.
  2. Submit the job to run the ALTER DATABASE commands.
  3. Check the completion status to confirm that the filegroups were created successfully.

Example

Use the following sample to create the filegroups listed. For example, to create the filegroup for table ARSDFBDT:

                                                               
# sqlcmd -d ODinstance 
                                                               
ALTER DATABASE CMOD_DB ADD FILEGROUP "ARSDFBDT";

Use the sample to create these filegroups:

  • ARSDFBDT
  • ARSDFDCT
  • ARSDFDRT
  • ARSDFDST
  • ARSDFLIS
  • ARSDFPPT
  • ARSDFUOT
  • ARSDFCRT
  • ARSDFEML

Verify or replace the following parameter in the ALTER DATABASE command example:

ODinstance
The Content Manager OnDemand instance database name to which the ODF tables and filegroups belong.