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: