I'm running the sqlserver backup activity that runs sqlmaint.exe and creates a filename with a given name (I don't give the backup the name). How can compress this backup file when it completes. Does it store the name in a variable somehow I can get to so I can zip up the files?
If not, how can I get compressed backups with sqlserver 2008?
We don’t get the backup filename back from SQLMaint as far as I can tell. One thing you could try is to make the backup path an empty folder, that way you just have to zip up all the files in the folder and then delete the files in the folder when done.