---
id: AA-00604
title: "Restoring a Demo Database"
url: http://netaphor.com/kb/AA-00604/restoring-a-demo-database
product: "SiteAudit OnSite"
type: "How-to & configuration"
updated: 2020-11-10
access: public
---


# Restoring a Demo Database

1. **Restoring SAB Demo Database**
2. SAB backups / restores should only be done for quick assessments. Production databases should be backed up using SQL Management Studio or scripts that produce .BAK files. To create a backup of your database using SQL script, refer to the article [Backing up Database using SQL Script](http://netaphor.com/kb/AA-00572).
3. SAB files are backup files that are created from within the Netaphor SiteAudit™ Viewer. These SAB files can be restored into an existing database. This section describes how to restore an SAB file into an existing database.
4. Restoring a Database
5. Restoring a database will overwrite all data in the existing database.
6. 1. Select **Setup** from the SiteAudit menu. Then select **Database **from the drop down menu**.**
7. 2. Click the **Maintenance** and then select **Restore (.SAB) **from the drop down list.

![](http://netaphor.com/kb/media/AA-00604/db-config.png)

![](http://netaphor.com/kb/media/AA-00604/db-restore.png)

1. 3. Select the database that you want to restore data into - note that all pre-existing data will be erased and cannot be recovered.
2. 4. Locate the .sab file to be restored into the current working database.

![](http://netaphor.com/kb/media/AA-00604/image010.png)

1. 5. **Note:** all existing data will be overwritten. Click the **Yes** button.

![](http://netaphor.com/kb/media/AA-00604/image011.png)

1. Click **OK **after completion:

![](http://netaphor.com/kb/media/AA-00604/image012.png)

1. Once this process is completed, any previous data will be replaced by the contents of the backup file. The database will be upgraded to the current schema version used by SiteAudit.
2. Restoring an SAB file
3. During the restoration of an SAB database, the progress indicator may not be present. Clicking anywhere on the application during this process may cause the application to indicate that it is not responding. However **DO NOT** force the application to close or stop the process. The restoration will eventually complete and a dialog will appear to show that the restore operation was successful.