In last week’s Tip of the Week I made this analogy:
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.
Then we proceeded to learn how to perform a Backup of the IntelliBid and JobTrac database. If you will recall, IntelliBid and JobTrac share the same database thus, only one database was required to be backed up. SureCount has its own unique database that also needs to be backed up separately. In case you missed last week’s Tip or you would like to review it, you can read Tip v7-19 now.
The steps for creating a backup for the SureCount database is very similar to the IntelliBid and JobTrac backup procedure.
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 -> SureCount -> select SureCount Admin Utility.
Once the Admin Utility dialog box opens (it may take a few seconds to locate the SQL Server), click Database Admin on the left menu.
(see image below)
- On the right side enter your ‘sa’ password.
Note: This password was created at the time you or your Network Admin installed IntelliBid v7.
- Click the Connect button to make the database connection.
- The Backup folder path should look like this example below. 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.
- Click the Backup Database button to begin the backup procedure. This should not take long at all.
- That’s all there is to it.
Typically, a Networked hard drive is backed up by an Administrator on a regular basis for security reasons. With that said, 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.
Please make note of the Backup Folder path: (as seen above in item #3)
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup
In the Backup folder, right click the mouse button and copy the SureCountDB.bak file to a safe location so that it can be retrieved in case of a disaster.