2

I've restored lots of SQL Server databases before but none quite this large. I got a 100GB+ .bak file that I restored recently but has been stuck with this "restoring" flag for about a half hour now.

Will it eventually go away?

I checked my resource monitor and didn't see SQL Server pulling a lot of processing/memory so I'm worried something has stalled. I can't query data from it until it goes away I'm guessing, says the database is inaccessible.

Screenshot:

enter image description here

1
  • Please show the SQL command that you run the restore. If you are doing this through SSMS, then click the "Script" button in the restore window.
    – Ivan
    Jun 13, 2022 at 9:00

1 Answer 1

3

Found an answer on this thread:

https://stackoverflow.com/a/1194863/12184700

RESTORE DATABASE <database name> WITH RECOVERY

The database still says restoring but I can now query it.

2
  • In SSMS object explorer select the Databases folder then refresh (blue circle arrow) Jun 12, 2022 at 10:16
  • 1
    While you have your answer, it's good to know why this was necessary. However you issued the restore statement (I.e. GUI or tsql), it had the norecovery clause on it. That shows you too restore additional backups (i.e. differential, log) on top of the full restore. Only when you're done with all of the intended restores do you "restore with recovery".
    – Ben Thul
    Jun 12, 2022 at 10:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.