How to Archive or Restore a Database with the Database Backup Manager

Archiving the database means you can save a copy of your database backup file(s) at your desired location. Those archived database files can be restored if needed.

If you want to take the copy of your backup files, you can do it manually by going to the location or you use the Archiving option in Paper Tiger itself.

Paper Tiger uses the SQL Server backup process to back up the database files. The backup files are stored in the “PaperTiger PTXXXX41 DBBackups” folder. SQL Server controls this folder, so you should be very careful in manually moving files in or out of this folder. In addition to the automatic backup, the database can be backed up at any time using the Database Backup Manager. It is located under the File menu.

Archiving a Database Backup

Should you want to take your database backup file and move it to a remote location, such as a server, flash drive or a CD-R to take home for an off-site backup, producing a backup file to do so with is simple. Follow the following steps:

1. Select Database Backup Manager from the File menu

2. Select Full Database from the Type of Backup area

3. Click on Backup Database

4. Select Create New Backup File from the Type of Backup area

5. Click on Backup Database again

6. Under the window area entitled Backup Files, select the second item from the top in the list of backup files

7. Click on Archive Backup File

8. Name the file you wish to save and select where it will be located

9. Click on Save

The most current backup file cannot be archived. Archiving a backup file requires that a newer backup file be generated first. This is to ensure that automatic backups can still occur when the program is closed.

Archived backups are not selectable/usable from the database manager window. They can only be selected by clicking on the Restore Archive File button.

Restoring Your Database from an Archived Backup File

When in need of restoring your database from an archived backup file,

1. Select Database Backup Manager from the File menu

2. Click on Restore Archive File

3. Browse to and open the specific file you wish to restore from

4. Select the newly restored backup file

5. Click on Restore Database

6. A confirmation window appears asking if you chose the correct database restore point. Click yes if you are positive you have chosen the correct point

Follow the following link for documentation on how to use the Database Backup Manager.

http://www.thepapertiger.net/DownloadManager.aspx?Topic=1002


Can't find the right answer?

  • Contact our support team and we will personally get back to you as fast as we can.