Simple Steps to Prepare Mirror Database for Mirroring in SQL Server
Posted
on SQL Server Central
See other posts from SQL Server Central
Published on Wed, 20 Jun 2012 06:00:00 UT
Indexed on
2012/06/20
9:22 UTC
Read the original article
Hit count: 217
Filed under:
To prepare a database for mirroring, you need to perform the following steps: Script the restore of the latest full database backup, script the restore of every transaction log backup that has been made after that full database backup, copy the full database backup and transaction log backups to the mirror server, and run the restore scripts on the mirror server. In this tip I will walk through these steps and provide sample scripts to prepare a database for mirroring.
© SQL Server Central or respective owner
