What are the challenges you face when working across database platforms? Take the survey
Options

Split large backup files

bn8959bn8959 Posts: 3
edited March 17, 2008 10:10AM in SQL Backup Previous Versions
Hi,

We run backups of many databases that are published for clients to download over https. We have a problem that HTTP only support files up to 4Gb. Our backup files range from 1meg to 20Gb. Is it possible to set sql backup to split files over 4Gb in size?

I have seen the split file option, however that appears just to split the backup in to a particular number of files - I only want to split files when they exceed 4gb (ie. no backup file larger than 4gb).

Any help would be appreciated.

Many Thanks
Ben

Comments

  • Options
    peteypetey Posts: 2,358 New member
    No, it isn't possible to split files that way. You will need to use another application to perform the splitting and the eventual merging.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    Thank you for the reply. Bit of a pain really. Im not sure why you would to 'split backups in to X files' and not 'split files over X MB'. Feature request :wink: ?
Sign In or Register to comment.