AuditWizard - Administration - General - Sending Your Database to Support

Back to Contents

Overview

On occasion, Support may need to examine your database to understand the cause of an issue or to repair your database. There is a preparatory procedure, and two different procedures depending on whether you are using the embedded database or a SQL Server database.

Preparatory Steps

Gather Information About the Database

Collect the following information for later use:

1. The application version of your installation of AuditWizard.
2. The type of database in use.
3. If AuditWizard security has been enabled, the password for the built-in admin account. If you have security concerns about sending the database with the admin password, change it prior to backup and sending.

Create Database Backup

Back up only the database that is in use. It will be either embedded (SQL Compact) or SQL Server.

Embedded (SQL Compact) Database)

1. In Windows Explorer, go to C:\Program Files (x86)\AuditWizard v8\db\.
2. Zip aw_db.sdf.
3. Move the .zip file to a location that will be easy to access.

SQL Server Database

1. Use SQL Server Management Studio (SSMS) to back up the SQL database to a .bak file. Note the following settings:
   

   
   
   

Prepare File for Upload

Rename the Backup File

Please use this naming convention for the backup file:

   aw_VERSION_sqlVERSION_YEARMONTHDAY.EXTENSION

For example, if you were backing up a version 8.4.4 embedded (SQL Compact) database on 7 Dec. 2016, the resultant filename would be (.zip extension from the zipping procedure):

   aw_844_sqlc_20161207.zip

If you were backing up a version 8.4.4 database running on SQL Server 2014 on 7 Dec. 2016, the resultant filename would be:

   aw_844_sql2014_20161207.bak

Zip the Backup File

Important! You must zip the file before sending to greatly reduce its size.

Send the Database

Send the .zip file to Support via our secure upload service.

Back to Contents