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 - 2002-02-01 : 07:56:27
|
| Prabhakanth writes "I have a database in SQL Server2000 which is around 25GB and I need to take a backup of this database. The problem is i dont have enough space for it. I only have about 10GB of space. So what i wanted to know is "Is there a way, i can take a compressed database backup". ie. the database should get compressed first and then the backup should take place. Please reply ASAP.Thanks Prabhakanth" |
|
|
penumatsa
Constraint Violating Yak Guru
289 Posts |
Posted - 2002-02-01 : 08:35:09
|
| SQL Server does not provide the option to compress the database before you back it up. But there may be third party tools that may do that.suresh penumatsa |
 |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2002-02-01 : 09:13:25
|
| Can you use a differential backup strategy |
|
|
|
monkeybite
Posting Yak Master
152 Posts |
Posted - 2002-02-01 : 11:14:59
|
| Try backing it up to a compressed directory on an NTFS partition . . . might save you around 20% or so in size.--monkeybite |
|
|
|
monkeybite
Posting Yak Master
152 Posts |
|
|
|
|
|
Compressed Database Backup