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 |
|
cindylee
Yak Posting Veteran
55 Posts |
 Posted - 2004-12-02 : 23:19:44
|
| Hello everyone,I need to backup a 140gb database. I have 3 local drives each has 70gb free space. I want to use 30gb in drive1,55gb in drive2,55gb in drive3. I know how to create a dump device, but i want to set a limit in each device, so it doesnt fill up the drive.Please Help |
|
|
pyeoh
Starting Member
18 Posts |
Posted - 2004-12-03 : 04:27:01
|
| You can't limit how much each device will use. You might use our free product, MiniSQLBackup Lite, to perform the backup. The Lite version will not backup to multiple devices, but if your database can be compressed to 25% of its size (on average), it will be able to fit on any of your available drives. If you absolutely need to backup to multiple devices, MiniSQLBackup costs only USD 99/- per named server.Peter Yeohhttp://www.yohz.comNeed smaller SQL2K backups? Use MiniSQLBackup Lite, free! |
 |
|
|
|
|
|
Large Database Backup in Multiple devices