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.
- Enterprise Edition.
- Standard Edition.
- Web Edition.
- 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.