This tool allows you to perform routine maintenance on your Print Audit database.
It leads you through each task in an easy to use wizard style interface so you can quickly perform each task, even if you know nothing about databases.
The tool presents you with different options depending on whether you are using a Microsoft Access or Microsoft SQL Server database as a back-end.
You chose which one you wanted to use when you installed Print Audit. The tool automatically detects which version you installed and displays the appropriate screens.
Part 1: Microsoft Access Maintenance
Compacting the databaseCompacting does several technical things to your database, but the most important thing from your perspective is that it reduces the size of the database, increases the speed of data access and reduces the chance of database corruption.
To compact the database using the wizard:
1. Start the Print Audit Database Maintenance tool. The tool starts on the Select Database Task screen. 2. Click the Compact your Database option.
3. Click the Next button. The wizard moves to the Select your Print Audit Database screen.
4. Enter the Print Audit database you want to compact. The wizard detects what the current database is on this computer. If you want to pick a different database, either type the full path to the database in or select it using the browse button.
5. Click the Next button. The wizard moves to the Ready to Compact screen and gives you a chance to go back and change things before you compact.
6. Click the Next button. The wizard starts to compact your database. When finished, it moves to the Finished screen and you are done.
Changing the Read-Only Password
For your convenience Print Audit provides a read-only login into your Print Audit database so you can use third party programs to access your data.
For example you may need to take the print job data and bring it in to another database in your organization for proper accounting.
Part 2: SQL Server Maintenance
Creating a New Database
The main reason to use the Print Audit Database Maintenance tool is to create a new Print Audit database on the SQL Server.
To create a Print Audit database:
1. Start the Print Audit SQL Server Maintenance tool. The wizard starts on the Enter SQL Server Login Information screen.
2. Enter the old SQL Server administration login password and click the Next button. The Select the SQL Server Task screen appears.
3. Click the Create a new database option.
4. Click the Next button. The Enter the Print Audit Database screen appears.
5. Enter the name of the new Print Audit database name in the text box or you can just use the default.
6. Click the Next button. If the Print Audit SQL Server login already exists the Ready to Create screen appears, otherwise the Enter the Print Audit Login Password screen appears. If the Ready to Create screen appears, skip to step 9.
7. Enter the new the Print Audit login password.
8. Click the Next button. The Ready to Create screen appears. 9. Review the information on the Ready to Create screen.
10. Click the Create button to start creating the new Print Audit database. The SQL Maintenance tool starts to create the database. This can take a couple of minutes.
11. If Print Audit detects that it is necessary to change the SQL administrator (sa) password, the Changing the System Administrator Login Password screen appears. Otherwise you are done.
Changing the Print Audit Login Password
You can use the Print Audit Database Maintenance tool to change the Print Audit login password. This is the password that all Print Audit users use to connect to the database.
To change the Print Audit login password:
1. Start the Print Audit Database Maintenance tool. The wizard starts on the Enter SQL Server Login Information screen.
2. Enter the SQL Server administration login password and click the Next button. The Select the SQL Server Task screen appears.
3. Click the Change the Print Audit User Password option.
4. Click the Next button. The Change the Print Audit User Password screen appears. 5. Enter the new password for the Print Audit user login.
6. Click the Change button to change the password.
Running a SQL Script
You can use the Print Audit Database Maintenance tool to run any SQL script against the Print Audit database. You may need to run scripts to repair accidentally damaged databases, or to perform different database maintenance tasks.
To run an SQL script:
1. Start the Print Audit Database Maintenance tool. The wizard starts on the Enter SQL Server Login Information screen.
2. Enter the SQL Server administration login password and click the Next button. The Select the SQL Server Task screen appears.
3. Click the Run a sql script file option.
4. Click the Next button. The Enter the Print Audit Database Name screen appears. 5. Enter the name of the Print Audit database you want to run the script against. 6. Click the Next button. The Select a SQL Script File screen appears.
7. Type the path to the script file, or click the Browse button to open a standard dialog so you can look for the file. 8. Click the Run button to run the script. After the script has completed the Summary screen appears.