Backing Up the Databases to Be Mirrored
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 ...
Get Microsoft SharePoint 2010 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
