Using SQL Server 2008 R2 Mirroring
Restore Dbs to the mirror server in NORECOVERY Mode
1. Restore DB > Choose from device >
2. Click Add >
3. Locate the db to be restore, after choosing the db, Copy the db Name before clicking OK
4. Click Ok > Click Ok
5. Paste the Db Name you copied to the database name
6. Check the restore Box > Click on Options and choose (RESTORE WITH NORECOVERY) > Click OK
7. Repeat for each of the SharePoint Dbs
Mirror the SharePoint Databases
1. Right Click on the DB to Mirror > Go to Tasks > Mirror
2. Click on Configure Security > Click Next
3. Click No, you do not want to create a Witness > Click Next
4. Accept the Defaults (Listener Port:5022, Endpoint Name: Mirror > Click Next
5. Choose the Endpoint that will be the next Endpoint > Click Connect
6. Click Connect and test your authentication > Click Finish
7. Click Finish
8. Click Close
9. Start Mirror
-Ivan
Ivan Sanders My LinkedIn Profile, My Blog, @iasanders, MVP