![Auto close is enabled. Only databases with auto close disabled can be added to an availability group. To turn off auto close, set the Auto Close database property to False. - JBs Auto close is enabled. Only databases with auto close disabled can be added to an availability group. To turn off auto close, set the Auto Close database property to False. - JBs](https://i0.wp.com/jbswiki.com/wp-content/uploads/2022/05/image-14.png?resize=800%2C727&ssl=1)
Auto close is enabled. Only databases with auto close disabled can be added to an availability group. To turn off auto close, set the Auto Close database property to False. - JBs
![SQL SERVER - Set AUTO_CLOSE Database Option to OFF for Better Performance - SQL Authority with Pinal Dave SQL SERVER - Set AUTO_CLOSE Database Option to OFF for Better Performance - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/c/auto_close.png)
SQL SERVER - Set AUTO_CLOSE Database Option to OFF for Better Performance - SQL Authority with Pinal Dave
![SQL SERVER - Error - Auto Close is Enabled. Only Databases with Auto Close Disabled can be Added to an Availability Group - SQL Authority with Pinal Dave SQL SERVER - Error - Auto Close is Enabled. Only Databases with Auto Close Disabled can be Added to an Availability Group - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/wp-content/uploads/2017/11/ao-wiz-err-1.jpg)
SQL SERVER - Error - Auto Close is Enabled. Only Databases with Auto Close Disabled can be Added to an Availability Group - SQL Authority with Pinal Dave
![Worst Practice: Allowing AutoClose on SQL Server Databases | ITPro Today: IT News, How-Tos, Trends, Case Studies, Career Tips, More Worst Practice: Allowing AutoClose on SQL Server Databases | ITPro Today: IT News, How-Tos, Trends, Case Studies, Career Tips, More](https://www.itprotoday.com/sites/itprotoday.com/files/styles/article_featured_retina/public/uploads/2011/09/autoclose-595x335_0.jpg?itok=70qZwoZx)