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