Backup and Restore Company Data

You must backup your database often if you want to restore the data in case of loss.

 

Backup your company database very often and early. Make sure you backup database to a different disk and make sure the backup moves to a completely separate place (ideally off-site) to be sure that it is safe. The reason is that in case of fire to your computer, your backup data will be safe and secure.

Restoring is getting the backup data back.  

 

To Backup

  1. On the File menu, click Data Utilities and then select Back Up Company Data.

  2. Specify what database you want to backup, by entering its name.  The default database is the current database

  3. You will need to specify the file name and its location where the backup data must be saved. Enter the file name and its location for example, 'C:\mybackupdata\qbm.qbk. Click the browse button '...' to browse to the location

  4. Enter the login name and password, the user must be an administrator

To Restore

  1. On the File menu, click Data Utilities and then select Restore Data File

  2. Specify what database you want to restore, by entering its name. Note that the database name must be different than the existing database

  3. You will need to specify the file name and its location where the backup data is saved. Enter the file name and its location for example, 'C:\mybackupdata\qbm.qbk. Click the browse button '...' to browse to the location. Remember that the file must exists in order to be restored.

  4. Enter the destination for your database to be restored at. Note that the destination database must be different from the current database location.  The database is saved as name.mdf , and name_log.ldf where the name is the name of the file and .mdf is for your data file and .ldf is for the log file

  5. Enter the login name and password, the user must be an administrator