Introducing Arcserve Backup Agents and Options › Using Agents › Agent for Microsoft SQL Server › Database File Options

Database File Options

Using the Database File options, you can:

• View the list of files for the database and related information.
• Select the files to be restored in a Files and FileGroup restore, or the FileGroups to be restored in a Partial Restore.
• Change the location or file names of files during a restore. Use the location change function only when restoring from Full backups, or when using Automatic Selection.

You can move the files to a different location on disk either individually or using Move Rules. Move Rules can be applied to an entire database, individual FileGroup or Transaction Log, or to an individual file. You can specify rules to move files to a particular drive, directory path, or rename the file, all independently of each other. If you want to rename files at the Database or FileGroup level, you can specify a filename change using a wildcard pattern.

To change database file locations

1. On the Agent Restore Options dialog, select the Database File Options tab.

2. In the navigation tree, select one of the following options to apply the change:
   • Select the database, if you want to apply the rule to all of the files in the database.
   • Select a FileGroup or the Transaction Log, if you want to apply the rule to the files in a particular FileGroup or the Transaction Log.
   • Select the file, if you want to change just a single file.
3. Under Restore Database Files As, select one of the following options, as appropriate:

   Restore to Original Location

   Available at the Database level. Clears any changes to the drive letters, paths, and file names. You must still click the Apply button after selecting this option for the change to take effect.

   Restore to Original Location, Except

   Available at the Database, FileGroup and Transaction Log, and File levels. Applies the requested changes to the drive letter, paths and file names based on the location of the file when the backup was performed.

   Inherit Move Rules, Except

   Available at the FileGroup and Transaction Log, and File levels. Applies the requested changes to the drive letter, paths and file names based on the changes which have already been made.

4. In the box labeled Database Move Rules, FileGroup Move Rules, or File Move Rules, select one or more of the following options:
   • Select the Move To Drive check box and enter a different drive letter in the field beside it.
   • Select the Move To Directory check box and enter a different directory path in the field beside it.
   • Select the Filename Pattern Change check box, to change the filenames for the entire database, FileGroup, or Transaction Log. Enter a wildcard pattern that matches the names of the files you want to rename in the field below and enter the wildcard pattern that you want it to be renamed to in the to field.

     For example, if you want to rename all the files that begin with Group as Members, enter Group* in the field and Member* in the to field.

   • Select the Rename File check box and enter a different file name, to rename a single file.
5. Click the Apply button.

   The changes are applied to the tree.

   Note: If you make a different selection or close the Agent Restore Options dialog without applying the changes, the selections you made will be lost.

   If the rules you specify result in two files being given the same physical location on disk, a red indicator appears at the bottom of the dialog, and in the tree next to both the affected files and the object where the rule was applied.

6. Repeat steps 2 through 5 for each change you need to make.

   Note: If you are using a wildcard pattern to rename files, and the pattern for the original filenames does not match with one or more of the files to which it would be applied, a yellow indicator will appear at the bottom of the dialog, and in the tree next to both the affected files and the object where the rule was applied.