My log shipping job stopped suddenly. I'm getting this error:

2020-04-17 14:46:36.42  ----- START OF TRANSACTION LOG RESTORE   -----
2020-04-17 14:46:36.53  Starting transaction log restore. Secondary ID: '02d5e9cd-bd01-42d6-9a8b-9c79c2b13d01'
2020-04-17 14:46:36.55  Retrieving restore settings. Secondary ID: '02d5e9cd-bd01-42d6-9a8b-9c79c2b13d01'
2020-04-17 14:46:36.56  Retrieved common restore settings. Primary Server: 'SERVERNAME', Primary Database: 'DBNAME', Backup Destination Directory: 'D:\LOGShipping\LSSecondary', File Retention Period: 14400 minute(s)
2020-04-17 14:46:36.56  Retrieved database restore settings. Secondary Database: 'DBNAME', Restore Delay: 0, Restore All: True, Restore Mode: Standby, Disconnect Users: True, Last Restored File: D:\LOGShipping\LSSecondary\DBNAME_20200413181001.trn, Block Size: Not Specified, Buffer Count: Not Specified, Max Transfer Size: Not Specified
2020-04-17 14:46:36.64  *** Error: The restore operation cannot proceed because the secondary database 'DBNAME' is not in NORECOVERY/STANDBY mode.(Microsoft.SqlServer.Management.LogShipping) ***
2020-04-17 14:46:36.65  Deleting old log backup files. Primary Database: 'DBNAME'
2020-04-17 14:46:36.69  The restore operation completed with errors. Secondary ID: '02d5e9cd-bd01-42d6-9a8b-9c79c2b13d01'
2020-04-17 14:46:36.76  ----- END OF TRANSACTION LOG RESTORE     -----

Exit Status: 1 (Error)

How can I solve this problem?



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.