TFS Redgate Build with Temporary Server Type sometimes leaves DLM Database
Our team has recently started using SQL Change Automation to automate our Build Release pipeline for our SQL installations via TFS. We have cross database dependencies so we use our dev server as a Temporary Server to build our databases.
This works well, but I noticed recently we've got some stale dlmautomation_(guid) databases building up on the dev server. I assumed there's some condition where they are not being deleted, so I tried queuing a build and then cancelled it in TFS and noticed the dlm database was not removed from the dev server.
Whats the best way to keep from having to pick up after these stale databases?
Thanks in advance!