I was doing a favor to a friend and on a refferal talked to a guy who didnt have anything but weekly backups and had a corrupt database due to some drive failures.
I was able to determine that the corrupt data was repairable if we had a copy of the old db, and since it was a tiny machine system I asked "Would you mind restoring the backup side by side with production and I can do what I need?"
"Sure thing!"
I wait for a minute, and then my connection to the production database dies.
I refresh the client, and now the one database available is restoring from a backup...
I called him and asked if he meant to overwrite his production copy with his backup instead of do it side by side, and he says petulantly, "I didnt do that!"
I ask him to check again, and he responds with "I will call you right back!"
Five minutes later I get the call, "How do I roll back my restore partially through the restore process?"
I was able to determine that the corrupt data was repairable if we had a copy of the old db, and since it was a tiny machine system I asked "Would you mind restoring the backup side by side with production and I can do what I need?"
"Sure thing!"
I wait for a minute, and then my connection to the production database dies.
I refresh the client, and now the one database available is restoring from a backup...
I called him and asked if he meant to overwrite his production copy with his backup instead of do it side by side, and he says petulantly, "I didnt do that!"
I ask him to check again, and he responds with "I will call you right back!"
Five minutes later I get the call, "How do I roll back my restore partially through the restore process?"
Oops.