As we go along in our busy day we take many things for granted. We grab something quick for breakfast on our way to the office or the job site, spend some time in a walk-through, plunk down in front of the computer, spark up IntelliBid, SureCount or JobTrac and work on an estimate or two. On the other hand, you work at the job site all day, come home and grab a quick bite to eat and work until late at night on that project you’d love to get your hands on. Then something unexpectedly happens, your computer has an electrical hiccup, or you somehow get a malicious virus that corrupts your hard drive or even worse, the hard drive decides to go up in smoke.

All your time and hard work is on that hard drive and you cannot get it back. Not matter what you try or who you call, that data cannot be retrieved. The first question that you’d be asked is; ” Did you back up your database or hard drive? ” The answer you should be able to give is a resounding “ YES I did ! ” However, if your are of the mind set that you’ll get to backing it up some time, that some time should be now.

Backing up your IntelliBid, JobTrac or SureCount database is very simple and will take only a few minutes of your day to perform. This is what you need to know; IntelliBid and JobTrac share the same database and the steps below will allow you to backup one database that covers IntelliBid and JobTrac . SureCount has its own database, so please plan your backups according to the product you own.

Whether you have Microsoft Windows Vista, XP or 7 ; click on the Start menu at the bottom left corner of the screen and go to -> All Programs -> ConEst Software -> select Admin Utility. Once the Admin Utility dialog box opens, clickBackup database on the left menu.IBv7_Backup

1. Enter your ‘sa’ password.
Note: This password was created at the time you or your Network Admin installed IntelliBid.

2. Click the Connect button to make the database connection.

3. The Backup folder path should look like this example above. If not, click on the Locate button on the far right and locate the Backup folder.
Note: The Backup folder is typically located on your local ‘C:’ drive unless the database has been installed on a Networked drive.

4. Click the Backup button to begin the backup procedure. This should take a few minutes.

5. That’s all there is to it.

However, if your database is not connected to a Networked hard drive, then it still resides on your local ‘ C: ‘ hard drive. For better security and protection of your local database, you can make a copy of the new database and store it in another safe location such as a portable Hard Drive or a pocket Thumb Drive. A 2GB or 4GB Thumb Drive will work fine. This way if your Hard Drive completely fails, you’ll have the database safe and secure in another location ready to be loaded on a new Hard Drive.

To make a copy of the database, make notice of the Connection Database name (see image above). Typically it isCE_DATA but if you have more than one database, it could have a number after it (i.e.. CE_DATA1, CE_DATA2, CE_DATA3).

You may also want to make note of the Backup Folder path: (below is a typical path unless it’s on a Network Hard Drive)

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup

In the Backup folder, right click the mouse button and copy the CE_DATA file or all other CE_DATA files that you have backed up. If you have SureCount installed you will notice the SureCount database resides in this Backup folder as well. You might as well copy that database to your remote storage for safe keeping also.

Path_to_IB_database

The Bottom Line: How often should you backup your data?  The answer is: How much data can you afford to lose?  If you can shrug off losing the last two weeks’ worth of work, then backup every two weeks.  If you can’t afford to lose more than a day, then backup daily.

 

Back to IntelliBid Tips Archive