SQL Database is in auto closed mode

  • 5 March 2022
  • 1 reply




Backup of one of my SQL DB is failing with error “Database is in autoclose mode”

On checking with DBA, they said that DB is in auto closed mode. But I am able to backup other DBs on same instance which is in auto closed mode.


Best answer by Stuart Painter 5 March 2022, 14:51

View original

If you have a question or comment, please create a topic

1 reply

Userlevel 7
Badge +15

Hi @Sharad Singh 

Thanks for the question and welcome to the Community!

AUTO_CLOSE mode in SQL Server enables SQL to close down the database when all connection resources are released.


So, it may be for this particular database, if all resources have been released and the database has been closed, Commvault is unable to perform a backup. Potentially other databases within the same instance are remaining open due to current activity.

You will need to ensure the database is in an active and available state before attempting to backup.