1

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?

2

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.