572
Part V: Enterprise Data Management
The Options page of the Restore Database form is shown in Figure 21-8.FIGURE 21-8
The Options page of the Restore Database form.The Options tab of the Restore Database dialog box offers a few signifi cant options:■ The Overwrite the Existing Database option disables a safety check that prevents
Database A backup from being restored as Database B and accidentally overwriting
an existing Database B.■ (^) The Preserve the Replication Settings option preserves the replication settings
when restoring a published database on a different SQL Server (other than the
SQL Server where the database was created). This option is available only with the
Leave the Database Ready for Use by Rolling Back the Uncommitted Transactions
option.
■ The Prompt Before Restoring Each Backup option prompts before continuing to
restore the next backup in the restore sequence. This option is useful when you
restore from tape backups and need to swap tapes.
c21.indd 572c21.indd 572 7/31/2012 9:22:52 AM7/31/2012 9:22:52 AM
http://www.it-ebooks.info