June 20, 2016 at 1:00 am
Good day Experts,
I have that a job which backs up all databases.All of a sudden the job is failing and when i check the logs for errors i get :
"Msg 9001, Sev 21, State 1, Line 1 : The log for database 'DREP' is not available. Check the event log for related error messages. Resolve any errors and restart the database. [SQLSTATE HY000]"
My Concern is why that error because the DREP DB is on Simple recoverry model which means that database won't have a log backup.All along it was working perfect.
Please help !!
June 20, 2016 at 1:40 am
Even if your database is in simple recovery mode it still has a log file. This error message indicates that this log file is missing or corrupted. If data and log files for your databases resides on different hard drives it could also be that the log drive is malfunctioning.
The first thing you could try is to restore the database from your last good backup. Also check the SQL server error log for possible messages related to this error.
June 20, 2016 at 3:48 am
The first thing you should do is find out if you actually have a problem. It may be a sign of an issue elsewhere (hardware, comms etc) so it would be worth spending some time getting to the root of the issue.
Is the database currently online, or is it offline/suspect or suchlike?
If it looks OK do you get any errors when trying to access it?
Any messages in the SQL Server error log that may be relevant?
What does DBCC CHECKDB tell you? It doesn't actually check the Log, but I'd run it anyway - to check the DB.
Can you run a checkpoint on the log?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply