Prerequisites for Configuring Log Shipping

The following are the prerequisites to configure Log Shipping in SQL Server.

  • Minimum 2 servers are required to configure the log shipping.
  • Both SQL & OS Editions and versions should be at same level on all participating servers,
  • Database must be in FULL or BULK LOGGED recovery model.
  • The SIMPLE recovery model is not support to configure the log shipping.
  • Any one the following editions need to be installed to configure the log shipping.
  1. Enterprise Edition.
  2. Standard Edition.
  3. Web Edition.
  4. Work group.
  • Express Edition doesn’t support SQL Server Log Shipping.
  • Both the servers should have same collation settings.
  • Both the SQL server agent services must be running.
  • SQL Server and SQL Server agent services must be running in Domain account.
  • The logon account must have local administrator privileges to carry out the administrative tasks. 
  • The user who configure the log shipping must be member of sysadmin server role in SQL server.
  • SQL server default port (1433) must be opened at network leave for communication between the both servers,
  • Sharing ports(135,137,138 and 139 or 445) must be opened on Production and DR servers for log shipping.
  • Should not run any maintenance plan or backup job against log shipping database since that would be break the log shipping chain.
  • Recommended to maintain same drive capacity in both the servers. 
  • Create shared network folders on primary and secondary servers.
  • Need to check the Computer name and SQL server name must be same. 

Prerequisites for Configuring Log Shipping

 

What is SQL Server Log Shipping

POA for Log Shipping Creation

SQL Server System Databases

Get SQL Dba Tutorial Updates!

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

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.

Add Comment