Data Base Mirroring in SQL Server

Database Mirroring is a one of the High Availability feature in SQL Server. Mirroring is database level HA. When you configure mirroring to any database, it should maintain three servers, there are

  1. Principal
  2. Mirror
  3. Witness

But witness server is an optional server. The client is connecting to principal server and accessing the database, at any time principal  server is down immediately  fail-over to mirror server(if witness server is available and running  ) otherwise do manually fail-over to mirror server.

To get more information about mirroring click on below link

database_mirroring

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s