Starting up database..... - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Starting up database.....

Author

Topic

petek
Posting Yak Master

192 Posts

Posted - 2009-07-23 : 04:46:34

Hi all,

I am not sure why but my log viewer is full of these messages

Starting up database 'DB NAME'.

Kind Regards

Pete.

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-07-23 : 04:58:43

GOOGLE says:
check db options and ensure you didn't enable 'auto close'.

No, you're never too old to Yak'n'Roll if you're too young to die.

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-07-23 : 05:00:50

If True, the database is closed, and its resources are freed when no user connection accesses the database.
Source: http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.database.autoclose.aspx

No, you're never too old to Yak'n'Roll if you're too young to die.

petek
Posting Yak Master

192 Posts

Posted - 2009-07-23 : 05:15:57

Hi i checked the DB option but its Auto Close is false.........

Kind Regards

Pete.

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2009-07-23 : 05:41:14

Are you using SQL Express by any chance?

petek
Posting Yak Master

192 Posts

Posted - 2009-07-23 : 05:41:53

Std edition......

Kind Regards

Pete.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-07-24 : 22:14:22

Its normal operation in error log. you shouldn't worry about it.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources