SQL Server issue and solution
Error: Log Shipping issues in SQL Server.
Out of Sync is the Common issue in Log shipping. It can be raised when Transaction Log Backups are not applied to the Secondary Server.
Error Summary: These are the two common errors that can occur during Log Shipping.
14420: This error occurs when the Backup Job fails. (From Primary Server)
14421: This error occurs when the Copy or Restore Job fails.(From Secondary Server)
Reason for the Error:
Scenario 1: If there is no disk space in the secondary server for restoring backups, then restore job fails hence 14421 error occurs.
Resolution:
Step 1: We must move the files into different disk where free space is available (or)
Step 2: Shrink the files in Primary Database.
Scenario 2: If there is no respective path to create the files in Secondary Server.
Resolution:
Step 1: Verify that the same path must be there in secondary server.
Step 2: Create the folder and grant read/write permissions to secondary server.
Step 3: If the respective drive is not available then we must manually restore using ‘WITH MOVE’ option.
Scenario 3: If there is Ad-hoc Transaction Log Backup was taken in the primary server, then Restore Job fails in Secondary server.
Resolution:
Manually copy and restore Ad-hoc Transaction Log backup into secondary server and run the restore Job.
