Creating .BAK Backup in SiteAudit Viewer

Creating .BAK Backup in SiteAudit Viewer

It is important to backup the Netaphor SiteAudit™ database periodically. How frequently the database is backed up should be dependent upon how critical the data is. In some environments, the data may not be critical and so backups may be done infrequently. In other environments where data is very critical, a backup may be scheduled to run every day. This article describes how to run a SQL script from within the SiteAudit Viewer that will backup the SiteAudit database.

Contents

• SQL Backup Script
• Running the SQL Backup Script
• Successful Backup
• Invalid Database Name
• Invalid Database Backup Path
  

The following is an example script used to backup a SiteAudit database. This script must be run on the same machine where the SiteAudit database resides.

BACKUP DATABASE [SiteAudit] TO DISK = 'C:\Temp\SiteAudit.bak' WITH INIT

In this example, the name of the database to backup is SiteAudit and the backup file will be stored in the C:\Temp folder and be given the name SiteAudit.bak. It is important to remember to always include the .bak file extension when creating the database backup.

It is possible to schedule a task to execute the SQL backup script periodically. For more information, see Scheduling SQL Backup & Shrinking Using the Windows Task Scheduler.

The following procedure describes how to run the SQL backup script to backup your SiteAudit database:

• Open the SiteAudit Viewer. (This can only be done on the same machine where the SQL Server is installed).
• Select Tools > SQL Query
• Copy the SQL script shown above and paste it into the Query window.
• Change the name of the database and the file name and path appropriately.
• Click the Execute button to run the script.
• Check the Message tab to confirm the script succeeded.
• Confirm the backup file exists in the specified location.