SQL Tutorials

MS SQL 2008 Server Mirroring Guide

MS SQL 2008 Server Mirroring GuideSQL server database mirror will help to avoid the database server downtime.If one database server done secondary database server will start working.In database Mirror database will copy in the every update  from the primary db server to secondary server.Here is the steps for Database mirror in SQL server 2008.






– Before start the mirroring in server.Must and should be install Active Directory in the primary DB server.
– First Add the features of Active directory from service manager.
– Once Active directory installed successfully restart the server.
– Now go to the second DB server.This server should be add to primary database server active domain.
– Both server should be under one domain.
– Create the database in the primary DB server and take the backup of the database.
– Go to Mirror server and create Db with the same name in the primary domain.If the database is   empty no need to restore the primary DB server Database in the Mirror server if not restore     DB and Transaction Log.

SQL Mirror2
– Now configure database Mirroring in Primary server.Using SQL server management studio.Right     Click on the Database and go to database properties.In the same window select Mirroring   option.

SQL Mirror3
– In next window it will ask for the witness server.If have witness server click on yes.But in    case we are not using witness server.So select No option.Click on Next.

SQL Mirror4
– Now it will ask for the Principal(Primary) Server Instance.option was default.Give the         endpoint name.If the listener Port no defined enter 5022 port number and click on Next.

SQL Mirror5
– In this window Mirror server Instance.Connect the Mirror server.Port Number and Endpoint name   should be same as Primary or Principal server.

SQL Mirror6
– In Next window It will show Service accounts Information.It will show the Primary and mirror   server details if not enter manually.

SQL Mirror7
– Complete the wizard click on Next.It displays the all configuration in this window.Click on next.

SQL Mirror8
– Configure Endpoints.It will take few min.

SQL Mirror9
– In this screen click on Start Mirroring button.

SQL Mirror11
– It will prompt that “To start mirroring without using a FQDN,Click “yes””click on yes.

SQL Mirror12
– In Database properties screen it will show Status Synchronized: The database are fully     synchronized.

SQL Mirror13
– Now can you can find the Mirroring in the primary server.It will show beside the database in   brackets(Principal,Synchronized).
SQL Mirror14


Tags:SQl,SQL 2005,SQL 2008,Ms Sql 2005,SQL installation,Ms sql2008,Mirror,Database mirror,SQl 2008 Mirror,SQL mirror,SQL 2005,Sql port forward,sql native client


About the author


1 Comment

Click here to post a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.