The log for database “dbname” is not available

Today, there was a log backup failure on SQL Server.  When I started looking at the SQL Server logs, I found the following error: “The log for database ‘dbname’ is not available. Check the event for related error messages. Resolve any errors and restart the database.  Error: 9001, Severity: 21, State:1.” I ran the sys.master_files view to make sure it had the correct physical name associated to the database but all looked just fine. At that point, my first thought was to run the DBCC CHECKDB command to look for corruption but I immediately received the same error. I decided to detach and attach the database but I was not successful. The last option I had was to set the database offline and bring it online which was the final solution to this issue. When bringing the database online, it recovered the database and rolled transactions forward.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s