T
T
tommy872016-06-20 16:41:19
Backup
tommy87, 2016-06-20 16:41:19

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

1 answer(s)
T
tommy87, 2016-07-21
@tommy87

The restart of the MS SQL service helped, which I did not want to do.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question