Maintenance plan backup task: databases with auto-close enabled are not backed up when the "Ignore databases where the state is not online" option is set - by Jon Seigel

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 697734 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 10/28/2011 11:17:10 AM
Access Restriction Public


Databases with auto-close enabled are ignored when the "Ignore databases where the state is not online" option is set in a maintenance plan backup task. This applies to all three types of backups.

I'm filing this as a bug given that the state of an auto-close-enabled database is ONLINE in sys.databases.

Note that in the maintenance plan, the View T-SQL window sometimes *does* show these databases in the script; however, when you actually run the job, it never backs them up.

I discovered this problem on 10.0.2531.0 (Enterprise 64-bit on Windows Server 2008 SP2 Enterprise), and reproduced under 11.0.1440 (Denali CTP3 on Windows 7 32-bit).
Sign in to post a comment.
Posted by Microsoft on 11/2/2011 at 12:42 PM
Thanks Jon, I have changed the status to fixed.The same issue is fixed for SQL Server 2008, SQL Server 2008 R2 and the information for Cumulative Update package is available at The fix got ported to upcoming release of SQL Server recently.
Posted by Jon Seigel on 11/2/2011 at 9:27 AM
Thank you for fixing this promptly.

The status of the item -- "resolved as not reproducible" -- I'm assuming this was a misclick?
Posted by Microsoft on 11/2/2011 at 2:41 AM
Greetings from the SQL Server Manageability team.

Thanks for writing in to Microsoft. We greatly value your feedback. We understand your problem, and how fixing this could improve productivity.

We were able to reproduce this issue, and we have fixed this issue. This will reflect in an upcoming release of SQL Server. Thanks again for providing feedback and making SQL Server the greatest Database server.