Does SQL Backup depend on a database named RedGate containing a table named SQLLighthouse.DDL_Events

drother

I am cleaning a server that I use for verifying backups.  The verification process is automated with SQL Backup.  The database is restored, verified and dropped.  At one time I had installed DLM Dashboard, but have since installed it.  Thinking this RedGate database was part of that, I took it offline and found that in doing so, my backup verifications would fail because the database to be verified would be restored to an offline status.  Events are being logged in the SQLLighthouse.DDL_Events table when the RedGate database is online.  Am I mistaken, is this database part of SQL Backup, or did I improperly uninstall DLM Dashboard?

Jessica R

Hi @drother,

Thanks for your post!

SQL Backup does not require this database- I suspect the issue is with the server trigger that was added by DLM Dashboard which you need to manually uninstall when you uninstall the tool.

Can you kindly try running the uninstall script provided here: https://documentation.red-gate.com/ddb1/uninstalling

Hope that helps!

drother

That seems to have solved it.  Thank you.

Jessica R

No worries, glad that helped!