August 26, 2014 at 10:53 am
Hi All, need help.
I try to make log shipping between different domain in the same forest, if I set for No recovery mode, it works fine.
I try to set it as standby mode with disconnect users after 30 mins to 1 hr, it fails and it shows restoring but if I want to recover it, it show suspect.
Both of SQL server are 11.0.3128.
Below is my error.
----error for log shipping job----
Message
2014-08-26 11:48:01.15Disconnecting users. Secondary DB: 'LogShipTest'
Message
2014-08-26 11:48:03.40*** Error: Could not apply log backup file 'C:\Tship\LogShipTest_20140826154010.trn' to secondary database 'LogShipTest'.(Microsoft.SqlServer.Management.LogShipping) ***
2014-08-26 11:48:03.40*** Error: An error occurred while processing the log for database 'LogShipTest'. 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 'LogShipTest' (5: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 'LogShipTest', file 'LogShipTest' on file 1.
Processed 1 pages for database 'LogShipTest', file 'LogShipTest_log' on file 1.(.Net SqlClient Data Provider) ***
Message
2014-08-26 11:48:03.48*** Error: Could not log history/error message.(Microsoft.SqlServer.Management.LogShipping) ***
2014-08-26 11:48:03.49*** Error: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.(System.Data) ***
2014-08-26 11:48:03.49Skipping log backup file 'C:\Tship\LogShipTest_20140826154010.trn' for secondary database 'LogShipTest' because the file could not be verified.
2014-08-26 11:48:03.49*** Error: Could not log history/error message.(Microsoft.SqlServer.Management.LogShipping) ***
2014-08-26 11:48:03.49*** Error: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.(System.Data) ***
2014-08-26 11:48:03.49*** Error: An error occurred restoring the database access mode.(Microsoft.SqlServer.Management.LogShipping) ***
2014-08-26 11:48:03.51*** Error: ExecuteScalar requires an open and available Connection. The connection's current state is closed.(System.Data) ***
2014-08-26 11:48:03.51*** Error: Could not log history/error message.(Microsoft.SqlServer.Management.LogShipping) ***
2014-08-26 11:48:03.51*** Error: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.(System.Data) ***
2014-08-26 11:48:03.51*** Error: An error occurred restoring the database access mode.(Microsoft.SqlServer.Management.LogShipping) ***
2014-08-26 11:48:03.51*** Error: ExecuteScalar requires an open and available Connection. The connection's current state is closed.(System.Data) ***
2014-08-26 11:48:03.51*** Error: Could not log history/error message.(Microsoft.SqlServer.Management.LogShipping) ***
2014-08-26 11:48:03.51*** Error: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.(System.Data) ***
2014-08-26 11:48:03.51Deleting old log backup files. Primary Database: 'LogShipTest'
2014-08-26 11:48:03.51*** Error: Could not log history/error message.(Microsoft.SqlServer.Management.LogShipping) ***
2014-08-26 11:48:03.51*** Error: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.(System.Data) ***
2014-08-26 11:48:03.51The restore operation completed with errors. Secondary ID: '1b48f389-bb5a-4a44-bd34-f3364dd6bca5'
2014-08-26 11:48:03.51*** Error: Could not log history/error message.(Microsoft.SqlServer.Management.LogShipping) ***
2014-08-26 11:48:03.51*** Error: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.(System.Data) ***
2014-08-26 11:48:03.51*** Error: Could not cleanup history.(Microsoft.SqlServer.Management.LogShipping) ***
2014-08-26 11:48:03.51*** Error: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.(System.Data) ***
2014-08-26 11:48:03.52----- END OF TRANSACTION LOG RESTORE -----
Exit Status: 1 (Error)
I try to check whether the log file have issue by logshipping to 2 servers on with norecovery and one with standby, one with norecovery
Seem to me the error on secondary database which service account for SQL server and SQL agent is domain service account and have admin right for the box.
Any help will be appreciated.
Thanks
JJ
August 27, 2014 at 2:08 am
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply