SQL Server: Database stuck in “Restoring” state

by

I had this situation restoring a database to an SQL Server 2005 Standard Edition instance using Symantec Backup Exec 11d. After the restore job completed the database remained in a “Restoring” state. I had no disk space issues– the database simply didn’t come out of the “Restoring” state.

I ran the following query against the SQL Server instance and found that the database immediately became usable:

RESTORE DATABASE <database name> WITH RECOVERY

More Related Contents:

  1. SQL Server backup/restore vs. detach/attach
  2. What is a simple command line program or script to backup SQL server databases?
  3. “No backupset selected to be restored” SQL Server 2012
  4. If condition in SQL Server 2008
  5. How to get the last row from a table in SQL Server?
  6. Comma separated results in SQL
  7. How do I fix the error ‘Named Pipes Provider, error 40 – Could not open a connection to’ SQL Server’?
  8. Which are more performant, CTE or temporary tables?
  9. Storing a file in a database as opposed to the file system?
  10. Preferred Method of Storing Passwords In Database
  11. How do you count the number of occurrences of a certain substring in a SQL varchar?
  12. Why is it considered bad practice to use cursors in SQL Server?
  13. Import Excel spreadsheet columns into SQL Server database
  14. Hitting the 2100 parameter limit (SQL Server) when using Contains()
  15. How do I backup and restore the system clipboard in C#?
  16. Query to list all stored procedures
  17. How do I search an SQL Server database for a string?
  18. SQL Server – parameter sniffing
  19. Does the order of columns in a WHERE clause matter?
  20. Can you call a webservice from TSQL code?
  21. How to safely use reserved SQL names?
  22. Comparing dates stored as varchar
  23. SQL Server: the maximum number of rows in table [closed]
  24. SQL Server 2008 Vertical data to Horizontal
  25. SSRS report definition is newer than Server
  26. Joining multiple tables returns NULL value
  27. Which join syntax is better?
  28. How to maintain the order of insertion in SQL Server
  29. What are row, page and table locks? And when they are acquired?
  30. Bootstrapping SQL Express from WiX?

Leave a Comment