SqlCloneTemp databases stuck Restoring
We have a dedicated server/SQL Server instance that we use for clone management. There are a couple of databases that start with SqlCloneTemp that seem to be stuck in the Restoring state - in fact, they've been there for over a month! The dashboard looks like all is healthy and there are no operations in progress that might involve the temp databases.
Any foreseeable issues if we were to just delete these temp databases?
Any foreseeable issues if we were to just delete these temp databases?
Best Answer
-
Eddie D Posts: 1,805 Rose Gold 5Hi emmar00,
Thank you for your forum post.
Please drop the left behind SqlCloneTemp databases, as everything looks healthy.
On the next occasion it occurs, it would be good to check both the SQL Clone Server and the SQL Clone Agent log files to see why the SqlCloneTemp database did not successfully dropped.
In my experience, it is some process preventing the database from being dropped or the temporary user created to perform any modification to an image can't be dropped as it still owns an object.
Many Thanks
Eddie