Database File Options
Chapter 4: Restoring Microsoft SQL Server Databases 55
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.
