December 2, 2004 at 1:10 am
Hi - sorry I'm posting so many queries - but I'm very quickly getting my head around what I need, thanks to the people in this forum.
In my Enterprise Manager, I can see that my server (MSDE on a dedicated W2003 Web Edition server) - says: 'datetime SPID5x Startingup database 'callist' - several times a day.
Is this indicating that the server hasbeen stopped, and needed restarted for some reason? I am not rebooting the server, or restarting any services.
Thanks for any pointers,
Mark
December 2, 2004 at 2:09 am
What is the setting for "autoclose" on this database?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
December 2, 2004 at 5:18 am
Hi Frank - AutoClose and AutoShrink are both ticked.
I can't see any more options for AutoClose though.
Kind regards, Mark
December 2, 2004 at 5:21 am
Okay, here's the explanation for your observation straight from BOL
Auto options control certain automatic behaviors.
AUTO_CLOSE
When set to ON, the database is closed and shut down cleanly when the last user of the database exits and all processes in the database complete, thereby freeing any resources. By default, this option is set to ON for all databases when using Microsoft® SQL Server™ 2000 Desktop Engine (MSDE 2000), and OFF for all other editions, regardless of operating system. The database reopens automatically when a user tries to use the database again. If the database was shut down cleanly, the database is not reopened until a user tries to use the database the next time SQL Server is restarted. When set to OFF, the database remains open even if no users are currently using the database.
The AUTO_CLOSE option is useful for desktop databases because it allows database files to be managed as normal files. They can be moved, copied to make backups, or even e-mailed to other users. The AUTO_CLOSE option should not be used for databases accessed by an application that repeatedly makes and breaks connections to SQL Server. The overhead of closing and reopening the database between each connection will impair performance.
The status of this option can be determined by examining the IsAutoClose property of the DATABASEPROPERTYEX function.
Uncheck this option.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply