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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-02-27 : 12:33:41
|
| Brendan writes "Hi,Could you please advise if there is anyway to reduce the size of full SQL 7.0 backup? I need to copy large backup files accross a slow network on a regular basis and so it would help if I could reduce the size of the backup. I am running SQL 7.0 with SP4.Thanking you...." |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-02-27 : 12:41:37
|
| You can reduce the size of a backup file by zipping it up. Typically a database will zip up in a 15 to 1 ratio. So if you're database backup were 15GB, it should be around 1GB after it is zipped up. This is just an approximation of course. |
 |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2003-02-28 : 14:45:22
|
| [url]http://www.sqllitespeed.com/slsdefault.asp[/url]HTHJasper Smith |
|
|
|
srf
Starting Member
42 Posts |
Posted - 2003-03-02 : 11:47:34
|
| Note you may need to split the file up before zipping it too. Most zip programs are limited to source files of 4 gigabytes or less, and often won't error out until you try to unzip on the destination system. We've also used SQL Litespeed and it works pretty good, if you have enough CPU the backups are faster as well. |
|
|
|
|
|
|
SQL 7.0 Database Backup Compression