Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
10Dawg
Starting Member
46 Posts |
 Posted - 2011-10-26 : 14:52:55
|
| I have limited space so every morning I go the my 3 sql servers (2-2005, 1-2008), zip up last night's backups and store them on a SAN. Is there anyway of automating this task within sql or with a 3rd party software?10Dawg |
|
|
Sachin.Nand
2937 Posts |
|
|
garipi82
Starting Member
4 Posts |
Posted - 2011-10-27 : 04:44:10
|
| There is a software which can help you, it is free and fully helpful ( easeus todo backup 3.0 ) it is a good softwer try it. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2011-10-27 : 13:30:40
|
| WinZip provide a command line version. There is also PKZIP which was always a command-line version. Just make sure you disable the errors messages which pause for you to press ENTER before it will exit! and use >>x:\SomePath\MyErrorFile.XXX to log all output for diagnostic purposes. If you use the MOVE operator then the original file will be deleted after successful ZIP. |
|
|
|
jpotucek
Constraint Violating Yak Guru
273 Posts |
Posted - 2011-11-17 : 15:18:53
|
| i use 7-Zip. it's open source and does a nice job. |
|
|
|
|
|
|
Automate zipping backups