How to schedule backup of SQL 2005, zip the backup and then send to network location
Posted on 2015-01-27
I am looking for a way to schedule a SQL 2005 backup of all databases to a folder, have that folder tagged with the day and date, then have the folder sent to a zip file (delete the remaining folder) and sent to a network location that requires user authentication
I would like to run this for 7 days per week, and have a separate backup for each day.
Is this possible? And if so, how?
I currently use the maintenance plan option in management studio, one for every day, and then zipping the file manually, then running robocopy to copy it to my network share.
I am sure there is a much better way of doing this though, hence the question :-)
Thank you in advance