AuditWizard - Using AuditWizard - Administration - General - Database Maintenance
(→User Defined Data Fields) |
m (Added link to "AuditWizard - Using AuditWizard - Administration - General - Database Maintenance - Database Purging") |
||
(17 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
− | <p align="right">[[File:btn_back_up.png|link= | + | <p align="right">[[File:btn_back_up.png|link=AuditWizard - Using AuditWizard - Administration]] [[AuditWizard - Using AuditWizard - Administration|<u>Back to Administration</u>]]</p> |
− | = | + | <p align="right">[[File:btn_back_up.png|link=AuditWizard - Using AuditWizard - Administration - General - Email Settings]] [[AuditWizard - Using AuditWizard - Administration - General - Email Settings |<u>Previous article in this series: ''Email Settings''</u>]]</p> |
+ | __FORCETOC__ | ||
+ | =Overview= | ||
+ | This article covers the various parts of the Database Maintenance tab. For a rundown of steps to remedy database issues, refer to '''[[AuditWizard - Troubleshooting - Database Maintenance|this article on troubleshooting]]'''. | ||
− | [[ | + | ='''[[AuditWizard - Using AuditWizard - Administration - General - Database Maintenance - Change Database Wizard|Change Database]]'''= |
+ | You can see which database you are currently connected to in this panel. ''C:\Program Files\AuditWizard v8\db\aw_db.sdf'' is the embedded SQL Compact Edition 3.5 database that all AuditWizard installations begin with. | ||
− | + | '''WARNING:''' The SQL Compact Edition database is purposed for trialing use only. Using the SQL Compact Edition database for a production AuditWizard installation is likely to become corrupted over time. Using the SQL Compact Edition database risks total data loss. | |
The Change Database procedure is used any time you want to change to a different SQL Server database. Usually this would be when migrating from the embedded database to SQL Server. | The Change Database procedure is used any time you want to change to a different SQL Server database. Usually this would be when migrating from the embedded database to SQL Server. | ||
− | If you are migrating from the embedded database to SQL Server, [[ | + | If you are migrating from the embedded database to SQL Server, '''[[AuditWizard - Using AuditWizard - Administration - General - Database Maintenance - Change Database Wizard - SQL Migration|see here for instructions]]'''. |
− | If you are changing your connection from one database to another without copying data, [[ | + | If you are changing your connection from one database to another without copying data, '''[[AuditWizard - Using AuditWizard - Administration - General - Database Maintenance - Change Database Wizard - SQL Connection Change|see here for instructions]]'''. |
− | |||
− | [[File: | + | [[File:Aw_admin_gen_db01.png|center|link=]] |
+ | ='''[[AuditWizard - Using AuditWizard - Administration - General - Database Maintenance - Database Purging|Database Purging]]'''= | ||
Enable or disable automatic purging. Choose individual timeframes for Asset History, Internet Records and Non-Audited Assets. | Enable or disable automatic purging. Choose individual timeframes for Asset History, Internet Records and Non-Audited Assets. | ||
You can force a purge immediately by clicking the ''Purge Now'' button. | You can force a purge immediately by clicking the ''Purge Now'' button. | ||
− | |||
− | |||
+ | [[File:Aw_admin_gen_db02.png|center|link=]] | ||
− | [[ | + | =Import & Export= |
+ | See '''[[AuditWizard - Using AuditWizard - Administration - General - Database Maintenance - Import & Export|Import & Export]]'''. | ||
+ | =Database Maintenance= | ||
+ | Support may issue a query to repair or maintain your database. This interface is provided for convenience so that you don't have to leave AuditWizard to run the query in Management Studio. The query will be intended for one-time use. | ||
− | |||
+ | [[File:Aw_admin_gen_db04.png|center|link=]] | ||
− | + | Click the button to open the AuditWizard Database Maintenance dialog: | |
− | + | [[File:Aw_admin_gen_db05.png|center|link=|Use the AuditWizard Database Maintenance dialog to run custom SQL queries.]] | |
− | + | ||
− | + | ||
− | + | ||
− | [[File: | + | |
− | + | ||
− | = | + | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | |||
If Support has supplied you with a .sql file, click the ''Load SQL'' button, locate the file and load it. This will populate the SQL statement field. If you have been given a query in plain text via email, copy and paste it into the SQL statement field. Click the ''Run SQL'' button to run the query. | If Support has supplied you with a .sql file, click the ''Load SQL'' button, locate the file and load it. This will populate the SQL statement field. If you have been given a query in plain text via email, copy and paste it into the SQL statement field. Click the ''Run SQL'' button to run the query. | ||
− | <p align="right">[[File:btn_back_up.png|link= | + | <p align="right">[[File:btn_back_up.png|link=AuditWizard - Using AuditWizard - Administration]] [[AuditWizard - Using AuditWizard - Administration|<u>Back to Administration</u>]]</p> |
Latest revision as of 22:09, 9 March 2017
Previous article in this series: Email Settings
Contents |
[edit] Overview
This article covers the various parts of the Database Maintenance tab. For a rundown of steps to remedy database issues, refer to this article on troubleshooting.
[edit] Change Database
You can see which database you are currently connected to in this panel. C:\Program Files\AuditWizard v8\db\aw_db.sdf is the embedded SQL Compact Edition 3.5 database that all AuditWizard installations begin with.
WARNING: The SQL Compact Edition database is purposed for trialing use only. Using the SQL Compact Edition database for a production AuditWizard installation is likely to become corrupted over time. Using the SQL Compact Edition database risks total data loss.
The Change Database procedure is used any time you want to change to a different SQL Server database. Usually this would be when migrating from the embedded database to SQL Server.
If you are migrating from the embedded database to SQL Server, see here for instructions.
If you are changing your connection from one database to another without copying data, see here for instructions.
[edit] Database Purging
Enable or disable automatic purging. Choose individual timeframes for Asset History, Internet Records and Non-Audited Assets.
You can force a purge immediately by clicking the Purge Now button.
[edit] Import & Export
See Import & Export.
[edit] Database Maintenance
Support may issue a query to repair or maintain your database. This interface is provided for convenience so that you don't have to leave AuditWizard to run the query in Management Studio. The query will be intended for one-time use.
Click the button to open the AuditWizard Database Maintenance dialog:
If Support has supplied you with a .sql file, click the Load SQL button, locate the file and load it. This will populate the SQL statement field. If you have been given a query in plain text via email, copy and paste it into the SQL statement field. Click the Run SQL button to run the query.