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.

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:
   

   
   
   

Replace Passwords with Generic Password

This applies to SQL Server databases. If AuditWizard security has been enabled, all the passwords should be overwritten with a generic password to protect your passwords.

1. Restore the database with a different name.

2. Run this query to change the passwords for all users to the generic password:

   UPDATE USERS
   
   SET    _PASSWORD = 'UAPw0AAEy0e3EG/DKSGS4AyuUCb0JKdBCDN7AvAUMIc='

3. Backup the temporary database.

4. In Management Studio, delete the temporary database.

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