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
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
