snippetsqlMinor
Electricity off while shrinking database, how can I recover my database?
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
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.