April 19, 2021 at 6:47 am
one of the 3rd Party DB's is going to recovery state. Whithout any reason I could find.
The log shows one DBCC CHECKDB after another is running on that database.
Strange, I can access and query the db in ssms.
I did repair_rebuild and it is working again, but after some time the problem arises again.
Any ideas on this?
April 19, 2021 at 9:19 am
Turned out, the database had AUTO_CLOSE on. and Backup with veeam caused the troubles.
April 19, 2021 at 11:44 am
Auto close is a pain. Happy you fixed it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 19, 2021 at 12:08 pm
Wow. I've never actually heard of any third party (nor anyone else, for that matter) using auto-close on a database before. Thanks for taking the time to post what you found. It's proof positive that it does happen in real life.
--Jeff Moden
Change is inevitable... Change for the better is not.
April 19, 2021 at 2:17 pm
yepp, it was my fault to not check the db for policies. It was a software called TCPCM by Siemens (!) checking the database for invalid objects, i found a few stored procs with invalid table references... seems to be a product of quality O_o.
I learned to take extra care whenever I have to permit an installer to create a database...
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply