AuditWizard - Administration - General - Sending Your Database to Support
m (Jpainter moved page AuditWizard - Administration - General - Sending your Database to Support to AuditWizard - Administration - General - Sending Your Database to Support: Corrected case of "your") |
(New section: "Replace Passwords with Generic Password") |
||
Line 10: | Line 10: | ||
#The '''[[AuditWizard - Administration - General - How to Find the Version Number#Application Version|application version]]''' of your installation of AuditWizard. | #The '''[[AuditWizard - Administration - General - How to Find the Version Number#Application Version|application version]]''' of your installation of AuditWizard. | ||
#The '''[[AuditWizard - Administration - General - How to Find the Version Number#Type of Database|type of database in use]]'''. | #The '''[[AuditWizard - Administration - General - How to Find the Version Number#Type of Database|type of database in use]]'''. | ||
− | |||
==Create Database Backup== | ==Create Database Backup== | ||
Line 22: | Line 21: | ||
===SQL Server Database=== | ===SQL Server Database=== | ||
#'''[https://msdn.microsoft.com/en-us/library/ms187510.aspx Use SQL Server Management Studio (SSMS) to back up the SQL database to a .bak file]'''. Note the following settings:<br /><p>[[File:Aw db backup 01.png|link=]]<br /><br />[[File:Aw db backup02.png|link=]]</p> | #'''[https://msdn.microsoft.com/en-us/library/ms187510.aspx Use SQL Server Management Studio (SSMS) to back up the SQL database to a .bak file]'''. Note the following settings:<br /><p>[[File:Aw db backup 01.png|link=]]<br /><br />[[File:Aw db backup02.png|link=]]</p> | ||
+ | |||
+ | ==Replace Passwords with Generic Password== | ||
+ | This applies to SQL Server databases. If '''[[AuditWizard - Using AuditWizard - Administration - General - Users and Security|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= | =Prepare File for Upload= |
Revision as of 00:24, 8 September 2017
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:
- The application version of your installation of AuditWizard.
- 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)
- In Windows Explorer, go to C:\Program Files (x86)\AuditWizard v8\db\.
- Zip aw_db.sdf.
- Move the .zip file to a location that will be easy to access.
SQL Server Database
- 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.