ExpressMaint is a utility which may be used to automate the backup of SQL Server databases.
It can be used to create and save a backup of each of the databases within an SQL Server. Better still it can be set to age the files, deleting all those older than, say, a month.
The ExpressMaint project home page is here: https://expressmaint.codeplex.com/
Download a copy of the zip file ExpressMaint.zip. Extract the ExpressMaint.exe file contained within to your scripts directory.
I’ll assume that the exe file has been added to the folder as: z:\ExpressMaint.exe.
I use a batch file to call the exe file, passing the relevant parameters.
And I have created a backup directory for the databases at z:\backup.
The batch file for running ExpressMaint is located at: z:\expmaint.cmd.
Contents of which are given below
"z:\expressmaint.exe" -S webserver\SQLserver -D ALL_USER -T DB -R "z:\dbBackup" -RU WEEKS -RV 4 -B "z:\dbBackup" -BU WEEKS -BV 4 -V -TO 20
In the above change the name of the server webserver and Sqlserver as appropriate.
shows example for individual database location
I created a scheduled task to run daily.
On Windows Server 2012 I found that expressmaint.exe wasn’t running as a scheduled task.
Searching for more information about the cause of the issue. I found this on stack exchange, which recommend using a later version of ExpressMaint:
I am actually using expressmaint with sql server 2012 express so u shouldn’t have any problems. make sure u use
https://expressmaint.codeplex.com/downloads/get/91612 which is version 2.0.0.1 and NOT 2.0.0.0
Stack Exchange article reference is:
Expressmaint with SQL Server 2012
Following the referenced link and using that version of ExpressMaint worked.
