February 16, 2006 | Mark Paradies

Tech Support Thursday: When Disaster Strikes

Let’s say you’re using your computer one day and suddenly the machine stops working. It won’t reboot. It won’t respond or even turn on any more. Suddenly you’re out of luck: What are you going to do? How are you going to get all of your old TapRooT System Software data back?

Well, if you don’t have an ‘official’ database backup of your TapRooT System Software (how to do this), all is not lost. Read inside to find out how to get your data back if you lack an official database backup.

First, a note: This is here for informational purposes only and is NOT a good Disaster Recovery plan. Official Database Backups using the Database Backup Utility is the best practice. Read about that here.

Okay, now that I’ve given you the lecture, let’s see move on to what we’re explaining here:

Your database is comprised of two files, a .mdf and a .ldf file. The MSDE (Microsoft Database Engine) keeps all of its data in these files, including Incident details, SnapCharTs, etc.

If you look at C:\Program Files\TapRooT, you should see a similar directory structure as the one shown here. The database files are in the taprootdata folder, as shown:

This is what C:\Program Files\TapRooT\taprootdata looks like

 

Note, If you do NOT have these files, you’re out of luck.

How to restore your database using these files

If you do have these files (and have thanked your local Admin for keeping good backups), then when you receive your new machine, do the following:

– Begin installing the TapRooT System Software.

– Complete all steps up to and including the Database Engine Installation section. This should complete and leave you looking at your desktop with the TapRooT System Software icon.

– The last step of the installation process is to actually install the databases themselves. This is where we are stopping because we must perform steps before that happens.

– Do NOT double click on the TapRooT System Software icon to begin the rest of the software installation. Instead, head to the C:\Program Files\TapRooT directory and paste your database files (the taproot_log.ldf and taproot_data.mdf as indicated above) into the C:\Program Files\TapRooT\taprootdata folder

– Double click on the TapRooT System Software icon on the desktop. This should begin the database installation. You should see a message pop up indicating that it has found database files and do you want to reattach these files. This is where you must say YES or your databases will not be reattached to the software and you will have to Remove the System Software and begin this process again.

If this sounds scary that’s because it should be—it’s to be used only in the case of a disaster. Remember, best practice is to keep good database backups and keep them updated regularly. Read about how to do this here.

If you’re still running into trouble, you can always contact us and we’ll be happy to help.

Thanks, and I’ll see you next week!

Categories
Software
Show Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

Follow us on Facebook
Follow us on Twitter
Check out our videos
Join us on LinkedIn