Download the program, save it to the local disc on the (SIMS) MSSQL server, I generally say create a batch file, but you can do whatever, run from command line…

Tidybackups.exe /PATH:(PATH TO YOUR MSSQLBACKUP) /DAYS:(NO OF DAYS) (/ARCHIVE)

For example: Tidybackups.exe /PATH:"C:program filesMicrosoft SQL ServerMSSQL10.SIMS2008MSSQLBackup" /DAYS:30 /ARCHIVE

This will delete any compressed files (.zip) and MSSQL backups (.bak) over 30 days old, any remaining MSSQL backups will be compressed, and the uncompressed version deleted.

Click here more information on the available switches

Last edited Nov 3, 2012 at 1:42 AM by matt40k, version 2

Comments

No comments yet.