SqlCloneTemp databases stuck Restoring

emmar00emmar00 Posts: 7 New member
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?

Best Answer

  • Eddie DEddie D Posts: 1,805 Rose Gold 5
    Hi 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
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.