Enables you to add new datafiles to a filegroup, Log group, and Temporary database group for SQL Server.
To open this dialog box, with the System Administration window open, click DBA > Add Datafiles.
Filegroup
This tab allows you to add new datafiles to a filegroup.
Filegroup — Allows you to select the filegroup to which you want to add a new datafile.
Data Window — Displays the read-only filegroup, file name, and data file location information.
New file information — Allows you to specify name and location, and the initial size of the datafile. The options are:
Datafile name — Allows you to enter the name of the new datafile that you want to add.
-
Datafile location — Allows you to specify the path on the file server where the new datafile will be located. The file path must include the drive and the datafile name.
-
Initial size — Allows you to enter the initial size of the new datafile, in MB.
Log Group
This tab allows you to add new datafiles to the Log group. For the option descriptions, see the information for the Filegroup tab.
Temporary Database
This tab allows you to add new datafiles to the Tempdb group. For the option descriptions, see the information for the Filegroup tab.
Apply
Adds the defined datafile to the filegroup, Log group, or Tempdb group.