Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 149
  • Last Modified:

How to schedule backup of SQL 2005, zip the backup and then send to network location

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
0
RPUKsupport
Asked:
RPUKsupport
  • 2
1 Solution
 
Lee SavidgeCommented:
There are dozens of ways to do it. This is the simplest:

http://www.sqlbackupandftp.com
0
 
Lee SavidgeCommented:
If you're doing it manually, why not put it all into a batch file and execute it via a Windows scheduled task, say 1 hour after the maintenance plan?
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now