Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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.

...


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

...

  • 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

Filter by label (Content by label)showLabelsfalsemax5spacesICXEshowSpacefalsesortmodifiedreversetruetypepagecqllabel in ("sql","backups") and type = "page" and space = "ICXE"labelssql backups


Page Properties
hiddentrue


Related issues