Skip to main content
Barracuda MSP Partner Toolkit

Disabling AutoClose for SQL Databases

This short guide will show you how to turn off AutoClose for a SQL database.  AutoClose must be disabled on a per-database basis and must be disabled in order for the Intronis software to back up those databases.



  1. Open SQL Server Management Studioautoclosefalse2.png and log into the SQL instance containing the database you want to back up.

  2. Expand the Databases folder to show the database you want.

  3. Right-click on the database and select Properties.

  4. In the Properties window, select the Options page on the left.

  5. Then, under the Automatic section, change the Auto Close value to False.

  6. Hit OK to save the change.


  • Was this article helpful?