Using SQL Server 2008 R2 Mirroring

Restore Dbs to the mirror server in NORECOVERY Mode

 

1. Restore DB > Choose from device >

clip_image001

 

2.  Click Add >

clip_image002

 

3. Locate the db to be restore, after choosing the db, Copy the db Name before clicking OK

clip_image003

 

4. Click Ok > Click Ok

5. Paste the Db Name you copied to the database name

clip_image004

 

6.   Check the restore Box > Click on Options and choose (RESTORE WITH NORECOVERY) > Click OK

clip_image005

 

7. Repeat for each of the SharePoint Dbs

Mirror the SharePoint Databases

1. Right Click on the DB to Mirror > Go to Tasks > Mirror

clip_image006

 

2. Click on Configure Security > Click Next

clip_image007

 

3. Click No, you do not want to create a Witness > Click Next

clip_image008

 

4.  Accept the Defaults (Listener Port:5022, Endpoint Name: Mirror > Click Next

clip_image009

 

5.  Choose the Endpoint that will be the next Endpoint > Click Connect

clip_image010

 

6.  Click Connect and test your authentication > Click Finish

clip_image012

 

7. Click Finish

clip_image014

 

8. Click Close

clip_image016

 

9. Start Mirror

 

-Ivan


Ivan Sanders My LinkedIn Profile, My Blog, @iasanders, MVP

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>