I'm using Windows Server 2003, Sql-Server 2005 and 7-zip for archiving.
Each day maintenance plan adds all DBs to backup and i need to archive those but just those files.
How do i create .bat or .vbs script which
- deletes previous archive
- adds only new (of this day) files to archive, while naming this archive 1sql_020810.7z (date)
I don't need help with 7-zip commands but with dos/vbs. I don't know how to get Current Date and Files of This Day to archive...