Showing posts with label Mirror. Show all posts
Showing posts with label Mirror. Show all posts

Monday, July 16, 2012

Implementation of Mirror Database Using SSMS

Implementation of mirror database consist of special set of step that enables the SQL to perform mirroring.
In this post I would be discussing the Mirror implementation from SSMS which is easy and in our next post we discuss about T SQL implementation.

Steps:


1. Take full full back up of principal database using right click -)Task-)backup-) full
2.Take transaction log back up of principal database using right click -)Task-)backup-) transaction log
3. Open Mirror Server right click  Mirror  database-)Task-)restore-) full
4. Open Mirror Server right click  Mirror  database-)Task-)restore-) transaction logs
5.Open Principal server go Task-) Mirror -) configure-)Set the principal-)Set the mirror-)Set the witness (if you want automatic fail over to mirror database in case principal database die)

And yes above Five steps are enough to start your mirroring using SSMS.
In our post we discuss about T -SQL implementation of mirroring

Popular Posts