SQL DBA Tutorial

What is SQL Server Log Shipping

What is SQL Server Log Shipping

Log shipping

Log shipping is one of the high availability method in SQL server.It is used to keep the entire database in different servers.

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

Primary Server: 

Secondary Server:

Monitor Server: 

Advantages: 

 

Click Below Links:

POA for Log Shipping Creation

Types of SQL Server Backups

Get SQL Dba Tutorial Updates!

Signup now and receive an email once I publish new content.

Thank you for subscribing.
Something went wrong.
I agree to have my personal information transfered to MailChimp ( more information )

I will never give away, trade or sell your email address. You can unsubscribe at any time.

Exit mobile version