Resources For IT Professionals
Post an article
Wikis - Page Details
  • First published by
  • When: 21 Jul 2013 1:04 AM
  • Last revision by (cMVP, Microsoft Community Contributo)
  • When: 17 Sep 2013 1:47 PM
  • Revisions: 6
  • Comments: 3
Options
RSSSubscribe to Article (RSS)
Can You Improve This Article?
Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.
Wiki  >  TechNet Articles  >  SQL VDI Backups Fail with Error 9001

SQL VDI Backups Fail with Error 9001

SQL VDI Backups Fail with Error 9001

Problem

The issue was with SQL backups failing in SQL 2008 server due to the SQL Server VSS writer as posted by the user in the forum.

Explanation

When backup is occurring through SQL VDI Backups, it requires 3 threads to perform the backups for a single database. The link below clearly tells how the SQL VDI Backups work.

http://blogs.msdn.com/b/psssql/archive/2009/03/03/how-it-works-sql-server-vdi-vss-backup-resources.aspx

So when the database Auto Close Property is set to true and when a thread from the SQL VDI Backup tries to freeze the IO on the database to take the backup it might fail with this error:

Event 9001

The log for database '' is not available. Check the event log for related error messages. Resolve any errors and restart the database.

It might also be followed by some other errors which are mentioned in the forum's thread.

If the database is configured for Auto Close Property set to true then, when there is no user activity on the database, the database will automatically close. As a best practice the Auto Close Property should be set to false.

http://blogs.msdn.com/b/buckwoody/archive/2009/06/24/sql-server-best-practices-autoclose-should-be-off.aspx

and also

SQL Server and Auto Close Setting

Solution

The errors might occur due to SQL Server not able to open the database quickly enough for the backup to complete or the database was in the middle of shutting down due to previous user activity on the database. So setting the Auto Close property of the database to false will have the SQL VDI Backups to complete successfully.

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/5d9ed48a-01eb-46f8-b78f-be566a7c803d/event-9001-log-is-not-available-during-backups

This entry participated in the Technology Guru TechNet WiKi for July 2013 contest and Won the bronze award.
, , , , , , [Edit tags]
Leave a Comment
  • Please add 6 and 6 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • 17 Sep 2013 1:47 PM

    Richard Mueller edited Revision 4. Comment: Modify title casing, change tag "SQL 2008" to "SQL Server 2008"

  • 21 Jul 2013 6:36 AM

    Naomi  N edited Revision 1. Comment: Minor edit, extra link to LTD, few more tags

  • 21 Jul 2013 3:43 AM

    rksqldba edited Original. Comment: Minor Edit

Page 1 of 1 (3 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Posted by
    on 21 Jul 2013 3:43 AM

    rksqldba edited Original. Comment: Minor Edit

  • Posted by
    on 21 Jul 2013 6:36 AM

    Naomi  N edited Revision 1. Comment: Minor edit, extra link to LTD, few more tags

  • Posted by
    on 17 Sep 2013 1:47 PM

    Richard Mueller edited Revision 4. Comment: Modify title casing, change tag "SQL 2008" to "SQL Server 2008"

Page 1 of 1 (3 items)