• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 152
  • 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

SMB Security Just Got a Layer Stronger

WatchGuard acquires Percipient Networks to extend protection to the DNS layer, further increasing the value of Total Security Suite.  Learn more about what this means for you and how you can improve your security with WatchGuard today!

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