CenterPoint Accounting - Backup and/or Restore a Single User Database

Backup and Restore Video - Duration: 7 min 24 sec


Document #: 3022 Product: CenterPoint®


Use this procedure to back up your accounting and/or payroll data onto a hard drive, zip drive, flash drive or tape drive. To copy the backed up files to the CenterPoint system, use the Restore feature. If you have payroll and accounting in the same database, the backup process will backup all data.

Backing up your CenterPoint data is one of the most important, yet also one of the most neglected areas of computing.Without data backup, you are running the risk of losing your data. Data loss can happen in many ways. One of the most common causes is physical failure of the media the data is stored on. Normally hard drives will work for years without incident, but eventually they may quit. It might happen gradually, by more and more bad clusters accumulating until most of the drive is unusable. Or it might happen suddenly, the hard drive just quits without warning. Another possible cause for data loss is power failure or spikes. 

It can result in loss of the data you are currently working on or in loss of your entire hard drive. Also worth mentioning is data loss through virus attacks. There are many computer viruses out there that will delete files on an infected machine.

It is recommended that you backup as often as you feel comfortable with having to recreate the data if something fails. For some organizations that could be daily and for others it could be once a week. Through CenterPoint, data can be backed up to a multitude of media types. Whichever backup media you select, you should always rotate each time you backup. In other words, don't backup to the same flash drive or CD each time. Make sure you have multiple backups available and rotate them. It's also recommended that you keep at least one backup stored off-site. In case of theft, flood, fire or other major catastrophe, you'll always have a complete record of your business finances.  

If you are using CenterPoint in a multi-user (network) environment, please refer to the Backup a Network Database document.

To restore a database back to the data included in a CenterPoint Backup, following the Restore a Backup instructions at the end of this document.

Note: Aatrix history files are backed up by selecting Reports > Federal & State Payroll Forms & Reports > Federal Tax Forms and clicking the Backup button. Click Yes and then click Save to backup all history files.

Backup a Single User Database

  1. On the File menu, select Backup Database.

  1. In the Database To Backup box, select the database that you want to backup. The database that is currently open will automatically display.
  2. In the Save To box, a default path displays. Click Browse, and then select the location on your own computer to save the backup file. Once you select the path to backup to, the last path used for backing up will automatically display each time you backup.
  • To backup to your own computer, select a location on the C:\ drive.
  • To backup to a server or remote computer, select a location on the network drive (for example, f:\ or g:\, etc.).
  • To backup to a flash (thumb) drive, select the drive letter that was assigned to the drive when it was inserted into the usb port on the computer.
Note: The file name for the backup file will be "databasenameMMDDYYYY.cpz." The database name plus the date of the backup will make it easy to identify which backup file you may need to use for a restore and it will prevent backups from being overwritten. If multiple backups are performed the same day, the Save To File Name will increment to ensure that it is unique and does not already exist in the Save To location.
  1. If you want to back up your screen settings, report favorites, and database preferences so they are available to restore if needed, leave the Back Up User Files check box selected. This option will prevent you from redefining your specific user files, favorites, and database preferences if a restore is necessary. If you always want this check box selected, right-click on the Back Up User Files check box and select Set As Default.
  2. If you want to be warned when the Save To backup location you are storing backups to exceeds a specified number of files or amount of space, leave the Warn Me check box selected. When the check box is selected, and then specify the conditions about when you want to be warned:
    • In the When the number of backups in this location exceed box, enter a number between 0 - 99.
    • In the When the size of the backups in this location exceeds box, enter a number between 0.00- 999.99 and select either MB (megabyte) or GB (gigabyte)
    • Setting either value to 0 disables that specific warning. For example, setting the When the number of backups in this location exceed box to zero will not warn you about the number of backups, but you will continue to be warned about the size of the backups according to your When the size of the backups in this location exceeds setting.
  3. To view the contents of the Save To backup location, click Open Backup Location.
  1. If you want to Close this screen when the backup completed, select this check box.
  2. Click Backup.
  3. At the Backup Completed Successfully message, click OK.

    Tip: Define a Preference that will automatically display the Backup screen each time you exit CenterPoint (just as if you selected File > Backup Database). To set the Backup preference:

    1. Select File > Preferences > General.
    2. Select Backup.
    3. Under Backup, in the Backup on Exit box, select Yes.

If you are backing up a database on a CD or DVD-RW Drive

  1. Use the procedure above to back up the data to a location on your hard drive. Note the location you are backing up to.
  1. From your Desktop, double-click the My Computer icon.
  1. Browse to the folder that you backed up the database to.
  2. Right-click on the backup file and select Send To and then select the CD drive. The message, You have files waiting to be written to the CD will display.
  3. From your Desktop, double-click the My Computer icon.
  4. Double-click the CD or DVD-RW drive. The screen will display the file(s) ready to be written to the CD or DVD-RW drive.
  5. Select File > Write These Files to CD.
  6. A CD Writing Wizard will display that will guide you through the remainder of the process by following the on-screen instructions.

Restore a Single User Backup

If the original data on your hard disk is accidentally erased, overwritten, or becomes inaccessible because of a hard disk malfunction, you can restore the data from a CenterPoint backup using the restore process. The restore process will revert all data back to the point when the backup was completed. All data that's been entered in CenterPoint since that backup was completed will be lost.

Use this procedure to restore a back up of your single-user accounting and/or payroll data from a workstation. If you have payroll and accounting in the same database, the restore process will restore all data back to the point the backup was completed. All existing data for the selected database will be overwritten during the restore process.

  1. On the File menu, click Restore Database.

  1. In the Backup File To Restore box, select the file you want to restore. Click Browse to locate the backup file (for example, from a CD or another hard drive). The file name for the backup file is "databasename.cpz".
  2. In the Database To Restore box, the database name that the backup file will be restored to will display.
Note: If you would like to change the name of the database, enter the new name instead of selecting from the list.
  1. In the Restore Databases Path box, the path that the backup file will be restored to will display.
  1. In the Server box, select the server where your database should be restored. If your database is local, typically, it is recommended that the default local\(RWS)server be accepted in this box.
  1. If you selected to restore a database that had the Back Up User Files option selected when the back up was performed, all of the user files will display. Please review the items that are included in the back up. It is important to note that if you are restoring from a source other than your original database, (for example your Accountant or Service Bureau backed up data and are now having you restore the data) that the selected items will be overwritten with their settings for reports, preferences, and screen settings unless you unselect the items you do not want to restore.
  2. Click Restore.
  3. At the You are trying to restore database "Databasename" If the database exists, all the current data will be overwritten with the restore database's data and cannot be retrieved. Do you want to continue? message, click Yes to continue restoring the database, or click No to cancel the restore procedure.
  4. At the Restore Completed Successfully message, click OK. The Restore Database screen will close automatically.

Concept Link IconSee Also