DESCRIPTION
ExpressMaint utility is a useful tool in automating the backup and maintenance of the Inventory Controller XE database installed on SQL Server 2005/2008/2008R2 Express Editions.
The ExpressMaint utility supports the following operations;
- Full Database Backup
- Differential Database Backup
- Log Backup
- Housekeeping of backup files
- Database Integrity Checks
- Database Index Rebuilds
- Database Index Reorganization
- Database Statistics Update
- Report Creation
Expressmaint Utility can be downloaded via the following links;
ExpressMaint utility for SQL 2005
ExpressMaint utility for SQL 2008
ExpressMaint utility Instructions and Sample Syntax is available via the following link;
ExpressMaint utility Overview
AUTOMATING BACKUPS USING ExpressMaint
Since SQL Server 2005 Express Edition does not include SQL Agent, we need to rely on the Windows Task Scheduler to run our maintenance tasks. If you are not familiar with how to set up a scheduled task, it's worth reviewing the Microsoft Knowledge Base article below
How to Schedule Tasks in Windows XP
- Double-click Add Scheduled Task to start the Scheduled Task Wizard, and then click Next in the first dialog box
- Click Browse, browse to Expressmaint.exe, and then click Open.
- Type a name for the task e.g DAILY FULL BACKUP and then choose Daily from the scheduling options
- Click Next, specify the information about the time to run the task e.g. 00:00, and then click Next
- Type the name and password of the account that will execute this task. Make sure that you choose an account that is a syadmin for your instance
- Click Next, select the checkbox to Open the Advanced Properties for this task and then click Finish
- In the Run text box append the arguments you want to pass to the ExpressMaint utility.(You must leave a space after the existing contents)
- Click OK. If prompted, supply the password for the account again.
How to Schedule Tasks in Windows Vista is available via the following link;
Vista - Schedule a Task
How to Schedule Tasks in Windows 7 is available via the following link;
Win7 - Schedule a Task
Related articles