Log Shipping in SQL Server

Log Shipping is one of the High Availability feature in SQL Server. In log-shipping  log records are transfered  from primary server to secondary server. When you configure log-shipping it required three servers but monitor server is optional. They are

  1.  Primary server
  2. Secondary server
  3. Monitor server (Optional)

Client connecting to primary server and accessing database, at any time primary server crashed or down, manually fail-over to secondary server. Automation is not possible in log-shipping.

When you participate database in log-shipping it must be full/bulked recovery model only.

To get more information about log-shipping click on below link.

log_shipping

 

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