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 |
|
hurricane59
Starting Member
4 Posts |
 Posted - 2004-09-27 : 06:00:37
|
| I want to make a backup of a database in severals files smaller than 2 Gb because of my util backup. It is possible?bests regards |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-09-27 : 06:25:35
|
| Can you ZIP or SPLIT the backup file after it is made, but before the util backup?(WinZip will make ZIP files in pieces up to a given size [and there is a command-line version, which I assume also has this ability])Kristen |
 |
|
|
MuadDBA
628 Posts |
Posted - 2004-09-27 : 14:34:48
|
| yeah, use multiple backup devices, it will split the db evenly across the multiple backup devices. no need to zip them later. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-09-28 : 09:28:02
|
| No way to constraint them to the 2GB limit though, is there?Kristen |
|
|
|
MuadDBA
628 Posts |
Posted - 2004-09-28 : 13:03:42
|
| ya got me there. You'd have to do a little SP for your backups, and use a number of files that would leave you with backup devices of less than 2GB. |
|
|
|
pyeoh
Starting Member
18 Posts |
Posted - 2004-09-28 : 22:09:59
|
| Give our product, MiniSQLBackup, a try. It'll compress the backup data during the backup process itself. Saves space and time to mess with 3rd party compression tools.Peter Yeohhttp://www.yohz.comNeed smaller SQL2K backups? Use MiniSQLBackup Lite, free! |
|
|
|
|
|
|
backup database with splited files