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.
| Author |
Topic |
|
meditdba
Starting Member
7 Posts |
 Posted - 2008-11-11 : 11:32:21
|
| I keep getting messages in my SQL Server 2005 log saying "Starting up database 'MRM'"... I have other databases on the server aside from MRM but this is the only one that has this message in logs. Any ideas?11/08/2008 23:54:06,spid132,Unknown,Starting up database 'MRM'.11/08/2008 23:53:32,spid132,Unknown,Starting up database 'MRM'.11/08/2008 23:40:22,spid132,Unknown,Starting up database 'MRM'.11/08/2008 20:46:49,spid193,Unknown,Starting up database 'MRM'.11/08/2008 20:46:39,spid193,Unknown,Starting up database 'MRM'.11/08/2008 20:41:57,spid193,Unknown,Starting up database 'MRM'.11/07/2008 20:34:12,spid140,Unknown,Starting up database 'MRM'.11/07/2008 19:38:52,spid140,Unknown,Starting up database 'MRM'. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-11 : 11:35:58
|
| Did you restore this database? |
 |
|
|
meditdba
Starting Member
7 Posts |
Posted - 2008-11-11 : 12:21:28
|
| If it was ever restored then just in the beginning, when DBAs originally put it out there. Since then, no. |
|
|
|
shaunc
Starting Member
28 Posts |
Posted - 2008-11-11 : 15:56:52
|
| It sounds like the Auto Close property is set on this database. There's extra overhead incurred each time the database is closed and started, so you should probably disable that option. |
|
|
|
|
|
|
|
|
Start up database ZZZ