Foo - I'm really glad for backup programs.

Bikeforums.net is a forum about nothing but bikes. Our community can help you find information about hard-to-find and localized information like bicycle tours, specialties like where in your area to have your recumbent bike serviced, or what are the best bicycle tires and seats for the activities you use your bike for.




mlts22
07-26-07, 11:42 AM
Did an OS upgrade on one machine. A couple days later, a conflict between the new OS, the SATA driver, and one other program, when it was told to defragment the system partition resulted in pretty much a DBAN-ing [1] of the system partition. Even running strings against /dev/hda resulted in nada... (and that is really bad.)

Thankfully, I back up my machines often (2-3x a day). So, I made a disaster recovery CD, booted it on the dead machine, told the backup server to do a restore over the LAN, wandered off, and had the machine fully restored from a dead state in about two hours.

Now, this morning, my phone crashed. Did a soft reboot, and it hung at the OS screen. Hard reset time. Copied a backup executable [2] to the phone's mini-SD card, ran it, told it to restore everything, and the phone was back up and running.

Moral of the story: Its really nice to have a backup system in place. Its also really nice to find that the backup system works when its needed.

[1]: dban.sourceforge.net -- Derik's Boot and Nuke. A great tool to run on machines to make sure nothing is on any of their hard disks before moving them to another department in a company.

[2]: SPB backup stores its backup files in .exe format, so one can just copy them to a phone and run it, restoring what is needed.


squegeeboo
07-26-07, 12:10 PM
Yah, back ups are great, if I had a nickel for every time I've destroyed the database at my job...well I'd have 10 cents, but at least the second time I had learned my lesson and had a back up in place.

(thankfully this was never in our live environment, only development)

BananaTugger
07-26-07, 12:16 PM
The only back-up I have is the crapload of games I have burned onto CD-R's from Steam. :p


mlts22
07-26-07, 01:05 PM
Yah, back ups are great, if I had a nickel for every time I've destroyed the database at my job...well I'd have 10 cents, but at least the second time I had learned my lesson and had a back up in place.

(thankfully this was never in our live environment, only development)

In IT, I have had this happen with DBAs. They would be logged in as sa, type in:

DROP TABLE FOO
<pause>
ROLLBACK

Seems they never realize that DDL commands (DROP, CREATE, ALTER) are synced immediately and never rollbacked.

This is also why you keep transaction log backups as well as regular backups.