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 |
|
GOPI
Starting Member
6 Posts |
 Posted - 2006-07-20 : 10:12:12
|
| Hi Team,I need to move the daily backups from prodn server to another remote Server - only after zipping it. The .bak file size is 4Gb and SQL 2005 on Windows 2003 is the environment.Can any of you help me with a script to zip the .bak files from one Server to another remote server? This has to be either a script or a job which gets executed daily night.Thanks in advance to You and to the community.Best regardsGopi |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-07-20 : 10:19:06
|
| I usually use the command line extension for winzip. Not sure if 7zip works on things that size now but winzip does.It's best to zip then copy if you can.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2006-07-20 : 12:53:30
|
| You also may want to look into SQL Litespeed. It's a tool that will backup and compress the backup. I've not used it, but many people on the boards speak highly of it.Michael<Yoda>Use the Search page you must. Find the answer you will. Cursors, path to the Dark Side they are. Avoid them, you must. Use Order By NewID() to get a random record you will.</Yoda>Opinions expressed in this post are not necessarily those of TeleVox Software, inc. All information is provided "AS IS" with no warranties and confers no rights. |
|
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2006-07-24 : 03:23:54
|
| I'm currently trying litespeed, which is pretty good, I do get around 50-80% size decrease with it, for a DB size around 19G native backup, with litespeed i get a backup file size of around 4G, no idea what they have done with it (someone can tell us if they know). |
|
|
|
Kristen
Test
22859 Posts |
|
|
schuhtl
Posting Yak Master
102 Posts |
Posted - 2006-07-24 : 10:08:44
|
| GOPI - Are wanting to restore your production backup on your remote server? The new version of LiteSpeed (if it is not out yet it should be out within several weeks) has built in Log Shipping. |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2006-07-24 : 17:03:16
|
| And don't forget two of SQLTeam.com's sponsors also have products in this area:http://www.red-gate.com/products/SQL_Backup/pro/index.htmhttp://www.idera.com/Products/SQLsafe/===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
|
|
|
|
Zip utility for backup