September 6, 2016 at 6:09 am
In sql server 2014 I have configured log shipping from my Prod to DR and secondary database I kept it in Standby/Read only mode. But after few days when I observe it went to Restoring state ....not sure how?
And when I try to execute recovery command on the same database it has thrown below error and the databases went to Suspect mode.
Cmd : restore database dbname with recovery.
Msg 9004, Level 16, State 6, Line 1
An error occurred while processing the log for database . If possible, restore from backup. If a backup is not available, it might be necessary to rebuild the log.
Msg 3167, Level 16, State 1, Line 1
RESTORE could not start database.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Msg 3414, Level 21, State 1, Line 1
An error occurred during recovery, preventing the database(10: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.
please suggest how to resolve this issue.
September 6, 2016 at 9:19 am
You had corruption, and your log shipped copy is in a bad state. You will need to restore a new full backup to the machine, to get things running again.
I would recommend looking through your SQL error logs, and Windows Event logs to see when the error occurred, and look for specific items that indicate the corruption happening. Most likely you will see storage errors presented (quite possibly 823).
September 6, 2016 at 9:43 am
Couple options:
i) You could may be just try restoring from a differential if you are concerned restoring from a full backup.
ii) You could try replaying old logs to see if it gets back online.
September 7, 2016 at 12:32 am
This was removed by the editor as SPAM
September 27, 2016 at 1:21 am
You can also check msdb database table named suspect_pages for possible reasons if it's related to corruption.
https://msdn.microsoft.com/en-us/library/ms191301.aspx
MJ
September 27, 2016 at 6:09 am
okay
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply