SQL DBA Log Shipping PROBLEMS

Troubleshooting Log Shipping:

•

1) Jobs disabled can be a cause for LS failure.

•

2) Backup Share permission issues.

•

3) Space issues in the backup share/local copy location.

4) SQL Server Agents stopped at Primary/Standy/Monitor.

5) Manual log backup can cause LS break.

•

6) Recovery Model change from Full/Simple.

•

7) Backup/Copy/Restore Job owner change can cause permission issues and break LS.

•

8) Network Issues with Backup Share.

•

9) WITH RECOVERY statement fired at Standy server can bring secondary database ONLINE breaking LS.

•

10) Service Account changes can lead to permission issues.

•

11) Log backups getting corrupted

•

12) Backup schedule is changed can cause lot of delay which might raise an alert.