October 2010
Intermediate to advanced
1008 pages
46h 16m
English
SQL mirroring works by creating an exact copy of a database on a separate server and then keeping that copy in sync with the original copy. To set up mirroring, the secondary, mirror server subsequently requires a restore of the original database to set up the initial mirror copy. That restore does not have to be an exact copy of the database as it is today, but it should be a relatively recent restore. After the mirror has been set up, the database will automatically replicate any changes made to the database since it has been backed up.
Both a full backup and a logs backup will need to be performed. These can be performed directly from the GUI, such as what is shown in Figure 17.4, or a TSQL script can ...
Read now
Unlock full access