database restarting 1

[davez]

Hi, im have a problem with one database in particular in that it constantly attempts to start: This continues throughout the day can anyone offer me as starting point on this one. No other database on the server have this problem.
2005-11-27 07:59:04.04 spid11 Starting up database 'database name'.
2005-11-27 07:59:08.17 spid12 Starting up database 'database name'.
2005-11-27 07:59:11.31 spid12 Starting up database 'database name'.
2005-11-27 07:59:15.29 spid11 Starting up database 'database name'.
2005-11-27 07:59:18.46 spid12 Starting up database 'database name'.
2005-11-27 07:59:19.64 spid12 Starting up database 'database name'.
2005-11-27 07:59:23.42 spid11 Starting up database 'database name'.
2005-11-27 07:59:26.79 spid12 Starting up database 'database name'.
2005-11-27 07:59:30.67 spid11 Starting up database 'database name'.
2005-11-27 07:59:34.04 spid12 Starting up database 'database name'.
2005-11-27 07:59:35.20 spid12 Starting up database 'database name'.
2005-11-27 07:59:38.92 spid11 Starting up database 'database name'.
2005-11-27 07:59:42.42 spid12 Starting up database 'database name'.

 

[mrdenny]

Open the database properties for the database and uncheck the auto_close checkbox, then click ok.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com