CODEWITHSUNDEEP
sqlsql-serverdatabasedatabase-backupsdatabase-restore
Sarah
Sarah

Reputation: 1293

SQL Database in restoring mode

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

Upvotes: 2

Views: 3253

Answers (2)

程兽医
程兽医

Reputation: 1

Don't do anything rash, You may just need to wait patiently!!!

Run the following sql to view the transaction log

EXEC xp_readerrorlog;

You’ll know the restore is working properly if you see output similar to the following:

2024-12-18 13:51:51.780|spid16s    |Recovery of database 'test' (7) is 11% complete (approximately 24303 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required. 
2024-12-18 13:51:59.720|spid16s    |Recovery of database 'test' (7) is 12% complete (approximately 24223 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.

Upvotes: 0

Terry Carmen
Terry Carmen

Reputation: 3886

"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.

Upvotes: 1

Related Questions