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 |
|
tech_1
Posting Yak Master
129 Posts |
 Posted - 2012-01-07 : 21:34:38
|
| Hi.for some reason im getting every few minutes alot of these event logs with 2 DB's always saying that it is starting DB {x} and then the next one in sequence starting DB {y}there are no connections to these databases at any time. not sure what is causing this to happen ever 2-4 minutes. And it is only ever these 2 specific DB's. There are 3 others but no event logs on themusing SQL Server 2008 R2 EEany ideas? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tech_1
Posting Yak Master
129 Posts |
Posted - 2012-01-08 : 06:51:16
|
| Thanks.the problem is though, it was never happening before. but then again it has had been a good few months before I checked the event logs.how would I disable auto close? But what would be accessing it causing to open itself? (nothing is on the system... it is my local computer). the only time it uses it when im developing against the DB but i havent for some time |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
biswajitdas
Starting Member
44 Posts |
Posted - 2012-01-13 : 10:18:25
|
| yep thats the correct soultion , I tested it on the test env.alter database [Database_Name] SET auto_close OFFSr Sql server DBA/Artitech |
|
|
|
|
|
|
Event ID 17137