Database Backup (in VM) stopping TableDependency

Nov 16, 2016 at 10:53 AM

We have found the scheduled db backups in a VM are stopping the TableDependency.

We didn't notice this in our testing, because no backup was performed at that time.

I think "dbcc freeze_io" is called which essentially puts the db in read-only mode while a snapshot is taken, and then "dbcc thaw_io" is called to re-activate write mode.

However, this causes an error in the SQL_Dependency and it is stopped.

Has anyone else come across this?

In my windows service, I would like to run a query to detect the state of the DB to see if it is in "Backing Up" Or "Frozen" state, and if so, I would like to stop the TableDependency and then restart it once the db has returned to normal operation.

Any help appreciated.