Categories
High Availability

Prerequisites for Log Shipping

The following are the prerequisites to configure Log Shipping SQL 2005

1. SQL Server 2005 Enterprise Edition, SQL Server 2005 Workgroup Edition, or SQL Server 2005 Standard Edition must be installed on all server instances involved in log shipping.

2. The servers involved in log shipping should have the same case sensitivity settings.

3. Enable Remote connections to the server in SQL Server surface are configuration, by navigating to start menu—>All Program—>Microsoft SQL 2005—>Configuration tools—>Surface Area Configuration tool—>Select Surface Area configuration for Services and Connections option—>Select Remote Connections—>Select Local and Remote connections by using TCP and Named Pipes option or else you can also use local and remote connections using TCPIP only and click OK.

log_shipping_prerequisites_1

log_shipping_prerequisites_2

log_shipping_prerequisites_3

4. The SQL Services in both the primary and secondary server should be the same with same password.Preferably a domain account.

5. The DB to be log Shipped should be in Full Recovery or Bulk logged recovery model,so that T-logs can be applied,else you cannot configure log shipping.Use the below command to change the recovery model or else you can change in the SSMS by right clicking the DB properties.

Use Master
GO
Alter Database DBName Set Recovery 'Recovery Model Name'

6. Shared folder should be created in Primary server to hold the tran log backups.

* Read/Write permission required —>For SQL service account of Primary for the tran log backup to be successful

* Read/Write permission required —>For SQL Agent account of Secondary for the copy job to be successful

* Read/Write permission required —>For SQL Service Account of Secondary for the restore job to be successful

By Deepak

Microsoft Most Valuable Professional (MVP) award-winning Database Designer with 5 years of experience in designing, administering, developing & performance tuning relational databases and data warehouse.

I possess strong leadership skills experience by serving as the Chapter Leader of Professional Association for SQL Server (PASS) which has around 50 members.

I am passionate about solving business problems using my technical skills and hence I am interested in the field of Technology Consulting in Information Management.

Leave a Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

*