Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Message "Starting up database " everyday in SQL Server log Expand / Collapse
Author
Message
Posted Monday, November 23, 2009 2:52 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, November 14, 2013 7:42 PM
Points: 326, Visits: 393
Hello all,

i am see this Message "Starting up database " everyday in SQL Server log.
Please tell me what could the reason behind this..

Generally as per my know if database is restored or brought online this message is seen.

SQL Server 2005 sp3 installed on my server
Regards
Ramu
Post #823146
Posted Monday, November 23, 2009 2:55 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, December 6, 2012 2:49 PM
Points: 140, Visits: 310
Select the database, right click properties--> Options-->Set Auto Close to False.
Post #823149
Posted Monday, November 23, 2009 3:46 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, November 14, 2013 7:42 PM
Points: 326, Visits: 393
thanks.. i will monitor the logs.
Post #823170
Posted Tuesday, November 24, 2009 10:40 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 3:59 PM
Points: 2,463, Visits: 424

Here is the simple alter statement you can use, just change the name of the database.

ALTER DATABASE MYDATABASE SET AUTO_CLOSE OFF
Post #824304
Posted Tuesday, November 24, 2009 10:47 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 3:59 PM
Points: 2,463, Visits: 424
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
Post #824306
Posted Wednesday, November 25, 2009 9:34 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, November 14, 2013 7:42 PM
Points: 326, Visits: 393
thanks it worked.
Post #824726
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse