Solved

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

Posted on 2015-01-27
2
125 Views
Last Modified: 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
0
Comment
Question by:RPUKsupport
  • 2
2 Comments
 
LVL 25

Accepted Solution

by:
Lee Savidge earned 500 total points
ID: 40572349
There are dozens of ways to do it. This is the simplest:

http://www.sqlbackupandftp.com
0
 
LVL 25

Expert Comment

by:Lee Savidge
ID: 40572351
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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
The following article is intended as a guide to using PowerShell as a more versatile and reliable form of application detection in SCCM.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question