5

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

Community
  • 1
Saw
  • 193
  • 5

1 Answers1

8

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.

datagod
  • 7,141
  • 4
  • 38
  • 58