HiveBrain v1.2.0
Get Started
← Back to all entries
snippetsqlMinor

Electricity off while shrinking database, how can I recover my database?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
canwhileelectricitydatabaserecoverhowshrinkingoff

Problem

While i execute shrink database, the electricity has been gone down, I can't access my database now, it is (In Recovery), how can i recover it?? Note: it is a very huge database: 25 GB.

EDIT:

My question on serverfault.com: https://serverfault.com/questions/395067/electricity-gone-off-while-shrinking-database-how-can-i-recover-my-database

Solution

Wait patiently for it to recover. This is what is supposed to happen. While waiting, try to track down your latest backup, just in case. I suggest a small investment in a UPS will avoid this problem in the future.

Context

StackExchange Database Administrators Q#18740, answer score: 8

Revisions (0)

No revisions yet.