Answer the question
In order to leave comments, you need to log in
I deleted the database, I can neither create nor restore it with the same name, what should I do?
There was a DB recovering by means of Log Shipping. At some point, the disk space ran out, the database became in an erroneous state. I deleted it, an error occurred during the deletion, but the database was deleted. It is not in sys.databases, but when I try to create a new database with the same name, it says that such a database already exists, when I try to restore from a backup, I get an error:
Msg 913, Level 16, State 8, Line 2
Could not find database ID 14. Database may not be activated yet or may be in transition. Reissue the query once the database is available. If you do not think this error is due to a database that is transitioning its state and this error continues to occur, contact your primary support provider. Please have available to review the Microsoft SQL Server error log and any additional information relevant to the circumstances when the error occurred.
Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.
Who faced it? How to treat?
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question