Previous Topic: Agent Restore Options - Microsoft SQL Server - Restore OptionsNext Topic: Restore the Arcserve Backup Database (Different Domain)


Agent Restore Options - Microsoft SQL Server - Database File Options

Arcserve Backup lets you specify Microsoft SQL Server restore options and the location to restore them.

The Database Files Options tab contains options and selections that control where you can restore your database.

Files or FileGroups

Choose the File or File Groups you want to restore from the tree.

Restore Database Files As
Restore to Original Location

Lets you restore the database to its original location. Available at the Database level. Clears any changes to the drive letters, paths, and file names. You must 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.

Move To Drive

Select the Move To Drive check box and enter a different drive letter in the field beside.

Move to Directory

Select the Move To Directory check box and enter a different directory path in the field beside.

Filename Pattern Change

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.

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.

Select the Rename File check box and enter a different file name, to rename a single file.

Click Apply for the changes to take effect.