SQL Backups - ExpressMaint utility

Owned by Former user (Deleted)
Last updated: Apr 12, 2017 by kbadmin
2 min read

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

Detail Steps

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.

 

Related Information

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


Need Assistance?
Call 1800 137 032 Email support@datapel.com