SQL Server Error Logs

Question

Post reply

SQL Server Error Logs

Lauren Hendricks

SSC Veteran

Points: 276
More actions
July 27, 2005 at 3:07 am

#88314

Hello,
A database that I am administering is experiecing odd errors - recorded in the error logs - the logs indicate that "Starting up database 'db_name'." - this occurs about 30 minutes.
Can anybody shed some light on the Error message ?
Thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 1

Is the database configured for autoclose?

SELECT DATABASEPROPERTY( 'db_name' , 'IsAutoClose' )

--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/

Lauren Hendricks SSC Veteran Points: 276 More actions · Answer 2

The database is set to Auto close - THANK YOU SOO MUCH!!!

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 3

No problem, happy to help. Note that starting up a database is an expensive operation, so if the database is not very seldomly used it should probably not be set in autoclose mode.

--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/