We have a database that we were doing a backup for, it has a TL of 550GB, I don't know why and how but it went in restoring mode.
Its been a couple of days now and its still in restoring mode. What are my options to fix this?
What does take offline do?
I just want it back in the same state that it was in..
Thanks
"Take offline" disconnects it from SQL Server. You can try it, however if it thinks it's stuck in a restore, you probably won't be able to take it offline.
After (if) "take offline" finishes, it will say "offline" and you can then select "Bring online" from the right click menu and bring it back online.
I hope you have good backups besides the one it just tried to do. You may end up needing to do an actual restore if it's really hosed.