AuditWizard - Administration - General - Sending Your Database to Support
From Layton Support
(Difference between revisions)
m (Jpainter moved page AuditWizard™ - Administration - General - Sending your Database to Support to AuditWizard - Administration - General - Sending your Database to Support: Removed the TM symbol for a cleaner URL) |
(Major revision) |
||
| 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> | <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. | + | __FORCETOC__ |
| + | =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: | ||
| − | #If you | + | #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]]'''. |
| − | + | #If '''[[AuditWizard - Using AuditWizard - Administration - General - Users and Security|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)=== | ||
| + | #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:<br /><p>[[File:Aw db backup 01.png|link=]]<br /><br />[[File:Aw db backup02.png|link=]]</p>[[File:Aw db backup02.png|link=]]</p> | ||
| + | |||
| + | =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 '''[http://laytontech.leapfile.net upload service]'''. | ||
<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 23:53, 6 December 2016
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.
- 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)
- 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:
</p>
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.
