SQL Instance monitoring stopped because of database restore
qcjims
Posts: 38
Is there a way to configure SQL Monitor to skip trying to connect to a database that is not online?
We are getting the following error on a system where we run a restore/DBCC checkdb of one of our critical prod databases.
Date Group Event Outcome Exception Exception message
4 Dec 2010 7:03 AM SQL #LVG Incorrect credentials or insufficient permissions SqlException Database 'SAP_AutoRestore' cannot be opened. It is in the middle of a restore.
This error stops monitoring on the entire instance instead of this one database.
-js
We are getting the following error on a system where we run a restore/DBCC checkdb of one of our critical prod databases.
Date Group Event Outcome Exception Exception message
4 Dec 2010 7:03 AM SQL #LVG Incorrect credentials or insufficient permissions SqlException Database 'SAP_AutoRestore' cannot be opened. It is in the middle of a restore.
This error stops monitoring on the entire instance instead of this one database.
-js
Comments
This is a known issue. It has been fixed in version 2.1 which should be released in the next week or so.
Cheers,
--
Daniel