Dear all,
I am having 3 server with same configuration one is production and other two is DR and Near DR
Suddenly something happens and DR and Near DR databases goes to restoring mode from standby/readonly mode.
Even I verified the .trn files it show's valid, even I checked the Disk there is no issues in the disk and I too checked the file share properties it is also fine.
please find the below error.
Date 9/22/2014 12:30:00 PM
Log Job History (LSRestore_JDCCBSQL_JDCCBPROD)
Step ID 1
Server JDCCB-MIS
Job Name LSRestore_JDCCBSQL_JDCCBPROD
Step Name Log shipping restore log job step.
Duration 00:00:15
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
2014-09-22 12:30:15.42 *** Error: Could not apply log backup file '\\Jdccb-mis\dr_logshipping\JDCCBPROD_20140922030012.trn' to secondary database 'JDCCBPROD'.(Microsoft.SqlServer.Management.LogShipping) ***
2014-09-22 12:30:15.42 *** Error: An error occurred while processing the log for database 'JDCCBPROD'. If possible, restore from backup. If a backup is not available, it might be necessary to rebuild the log.
An error occurred during recovery, preventing the database 'JDCCBPROD' (7:0) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support.
RESTORE LOG is terminating abnormally.
Processed 0 pages for database 'JDCCBPROD', file 'JDCCBPROD' on file 1.
Processed 0 pages for database 'JDCCBPROD', file 'MASTER_DATA' on file 1.
Processed 0 pages for database 'JDCCBPROD', file 'MASTER_INDEX' on file 1.
Processed 0 pages for database 'JDCCBPROD', file 'TRANS_DATA' on file 1.
Processed 0 pages for database 'JDCCBPROD', file 'TRANS_INDEX' on file 1.
Processed 1 pages for database 'JDCCBPROD', file 'JDCCBPROD_log' on file 1.(.Net SqlClient Data Provider) ***
2014-09-22 12:30:15.42 *** Error: Could not log history/error message.(Microsoft.SqlServer.Management.LogShipping) ***
2014-09-22 12:30:15.44 *** Error: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.(System.Data) ***
2014-09-22 12:30:15.44 Skipping log backup file '\\Jdccb-mis\dr_logshipping\JDCCBPROD_20140922030012.trn' for secondary database 'JDCCBPROD' because the file could not be verified.
2014-09-22 12:30:15.44 *** Error: Could not log history/error message.(Microsoft.SqlServer.Management.LogShipping) ***
2014-09-22 12:30:15.44 *** Error: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.(System.Data) ***
2014-09-22 12:30:15.44 *** Error: An error occurred restoring the database access mode.(Microsoft.SqlServer.Management.LogShipping) ***
2014-09-22 12:30:15.44 *** Error: ExecuteScalar requires an open and available Connection. The connection's current state is closed.(System.Data) ***
2014-09-22 12:30:15.44 *** Error: Could not log history/error message.(Microsoft.SqlServer.Management.LogShipping) ***
2014-09-22 12:30:15.44 *** Error: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.(System.Data) ***
2014-09-22 12:30:15.44 *** Error: Could not apply log backup file '\\Jdccb-mis\dr_logshipping\JDCCBPROD_20140922031512.trn' to secondary database 'JDCCBPROD'.(Microsoft.SqlServer.Management.LogShipping) ***
2014-09-22 12:30:15.44 *** Error: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.(System.Data) ***
2014-09-22 12:30:15.44 *** Error: Could not log history/error message.(Microsoft.SqlServer.Management.LogShipping) ***
2014-09-22 12:30:15.44 *** Error: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.(System.Data) ***
2014-09-22 12:30:15.44 Skipping log backup file '\\Jdccb-mis\dr_logshipping\JDCCBPROD_20140922031512.trn' for secondary database 'JDCCBPROD' because the file could not be verified.
2014-09-22 12:30:15.44 *** Error: Could not log history/error message.(Microsoft.SqlServer.Management.LogShipping) ***
2014-09-22 12:30:15.44 *** Error: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.(System.Data) ***
2014-09-22 12:30:15.44 *** Error: An error occurred restoring the database access mode.(Microsoft.SqlServer.Management.LogShipping) ***
2014-09-22 12:30:15.44 *** Error: ExecuteScalar requires an open and available Connection. The connection's current state is closed.(System.Data) ***
2014-09-22 12:30:15.44 *** Error: Could not log history/error message.(Microsoft.SqlServer.Management.LogShipping) ***
2014-09-22 12:30:15.44 ***