Home Forums SQL Server 2005 Administering Message "Starting up database " everyday in SQL Server log RE: Message "Starting up database " everyday in SQL Server log
Bulent Gucuk
SSCertifiable
Points: 5433
More actions
November 24, 2009 at 10:47 pm
#1083812
Here is the simple statement you can use to turn of Auto close option, just change the database name.
ALTER DATABASE MYDATABASE SET AUTO_CLOSE OFF