November 22, 2009 at 9:28 pm
hello SQL gurus
I have log shipping set up for 3 databases from my primary to secondary. For one of the database, in error logs I see "Starting up database (DBNAME)
Can someone please tell me why is this happening. It is not effecting my log shipping but I am curios about the message information.
Thanks
Ali
November 22, 2009 at 9:38 pm
How long is it showing the message?
What is the DB Size? It may be restoring the backup on the secondary server..
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 22, 2009 at 9:56 pm
This message is showing right from the begining of my set-up... I jsut noticed it today...
November 23, 2009 at 3:26 am
Check it and change it!
Select the database, right click properties--> Options-->Set Auto Close to False
November 23, 2009 at 8:14 am
what does that mean.. "AUTO CLOSE"
November 23, 2009 at 8:35 am
sqldba.jagan (11/23/2009)
what does that mean.. "AUTO CLOSE"
Quoting MSDN here
When set to ON, the database is shut down cleanly and its resources are freed after the last user exits. The database automatically reopens when a user tries to use the database again.
When set to OFF, the database remains open after the last user exits.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply