October 2010
Intermediate to advanced
1008 pages
46h 16m
English
After the database backups have been transferred to the mirror server, they should be restored onto that SQL instance. What is critical is that both the full backup and the logs backup must be restored with the NORECOVERY option chosen. If this is not chosen during the restore process, the mirror won’t be able to be created. If restoring using the GUI, choose the Restore with NoRecovery radio button in the Options tab, and be sure to do it for both database and logs restores, as shown in Figure 17.5.
Figure 17.5. Restoring the logs with No Recovery to set up a mirror copy.

You can also choose to ...
Read now
Unlock full access