AuditWizard - Administration - General - Sending Your Database to Support

From Layton Support
(Difference between revisions)
Jump to: navigation, search
m (Bolded links)
m (Bolded link)
Line 1: Line 1:
<p align="right">[[File:btn_back_up.png|link=User Guide for AuditWizard]] [[User Guide for AuditWizard|<u>Back to Contents</u>]]</p>
+
On occasion, Support may need to examine your database to understand the cause of an issue or to repair your database. Here are the instructions on how to send:
__FORCETOC__
+
On occasion, Support may need to examine your database to understand the cause of an issue or to repair your database.
+
  
=Determining Which Type of SQL Database is in Use=
+
#If you are using the embedded database, zip the file ''aw_df.sdf'', located in C:\Program Files\AuditWizard v8\db\.
==AuditWizard Method==
+
#If you are using a SQL Server, back up the database to a .bak file.
Open AuditWizard and navigate to Administration > General > Database Maintenance. The database connection appears in the '''[[AuditWizard™ - Using AuditWizard - Administration - General - Database Maintenance#Change_Database|Change Database section]]'''.
+
#'''Important!''' You must zip the file before sending to greatly reduce its size. Send either zip file to Support via our '''[http://laytontech.leapfile.net upload service]'''.
  
 
+
If you are using SQL Server, please indicate which version. If you are using AuditWizard accounts (AuditWizard-specific accounts used to log in to AuditWizard), please supply the password for the built-in ''admin'' account.
[[File:Aw db conn.png|center|link=]]
+
 
+
 
+
==Configuration File Method==
+
If AuditWizard cannot be launched, navigate to the location of the AuditWizard configuration file:
+
 
+
32-Bit Systems:
+
 
+
    C:\Program Files\AuditWizard v8\
+
 
+
64-Bit Systems:
+
 
+
    C:\Program Files (x86)\AuditWizard v8\
+
 
+
#Open ''AuditWizardv8.exe.config'' in NotePad.
+
#Search for the string ''CompactDatabaseType''.<br /><p>[[File:Auditwizard_database_config.png|link=]]<br/></p>
+
#If the ''CompactDatabaseType'' key is set to '''True''', then you are using the compact database. Continue with the steps for '''[[AuditWizard™ - Administration - General - Sending your Database to Support#SQL Compact|preparing the database]]''' below.
+
#If the ''CompactDatabaseType'' key is set to '''False''', your database is on the SQL Server as displayed in the ''ConnectionStringExpressDataSource'' key value. The database name is provided as the value for ''ConnectionStringExpressInitialCatalog''. Continue with the steps for '''[[AuditWizard™ - Administration - General - Sending your Database to Support#SQL Serrver|preparing the database]]''' below.
+
 
+
=Preparing the Database=
+
==SQL Compact==
+
#Navigate to C:\Program Files\AuditWizard v8\db\.
+
#Zip the file ''aw_db.sdf''.
+
 
+
==SQL Server==
+
#Use Microsoft SQL Management Studio to back up the database to a .bak file.
+
#Please indicate the '''version number''' of AuditWizard and the '''version of SQL Server''' you are using. It is suggested that you use this naming convention for the backup file:<p><code>lsd_VERSION_sqlVERSION_YEARMONTHDAY.bak</code></p>For example, if you were backing up a version 6.4.8.1 database running on SQL Server 2008 R2 on 29 April 2014, the resultant filename would be:<p><code>lsd_6481_sql2008r2_20140429.bak</code></p>
+
#Zip the .bak file.
+
 
+
=Sending the Database to Support=
+
'''Important!''' You must zip the file before sending to greatly reduce its size. Send either zip file to Support via our '''[http://laytontech.leapfile.net upload service]'''.
+
 
+
In the form provided on the upload service, please indicate which version of SQL Server you are using. If you are using AuditWizard accounts (AuditWizard-specific accounts used to log in to AuditWizard), please supply the password for the built-in ''admin'' account.
+
 
<p align="right">[[File:btn_back_up.png|link=User Guide for AuditWizard]] [[User Guide for AuditWizard|<u>Back to Contents</u>]]</p>
 
<p align="right">[[File:btn_back_up.png|link=User Guide for AuditWizard]] [[User Guide for AuditWizard|<u>Back to Contents</u>]]</p>

Revision as of 00:13, 6 May 2014

On occasion, Support may need to examine your database to understand the cause of an issue or to repair your database. Here are the instructions on how to send:

  1. If you are using the embedded database, zip the file aw_df.sdf, located in C:\Program Files\AuditWizard v8\db\.
  2. If you are using a SQL Server, back up the database to a .bak file.
  3. Important! You must zip the file before sending to greatly reduce its size. Send either zip file to Support via our upload service.

If you are using SQL Server, please indicate which version. If you are using AuditWizard accounts (AuditWizard-specific accounts used to log in to AuditWizard), please supply the password for the built-in admin account.

Btn back up.png Back to Contents

Personal tools
Namespaces

Variants
Actions
Main Page
Online User Guides
General Support
Release Notes
Toolbox