Database File Options
56 Agent for Microsoft SQL Server Guide
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.
