How can we help you today? How can we help you today?

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

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?


drother
0

Comments

3 comments

Sort by
  • 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!
    Jessica R
    0
  • drother
    That seems to have solved it.  Thank you.
    drother
    0
  • Jessica R
    No worries, glad that helped! :)
    Jessica R
    0

Add comment

Please sign in to leave a comment.