Specifying Output Backup File Size

Question

Post reply

Specifying Output Backup File Size

C Schaefer

SSC-Addicted

Points: 415
More actions
December 22, 2005 at 2:41 pm

#115791

Is there a way to separate 1 large DB backup into smaller individual files? I have a 6+ gig database that I need to write to media to send to a colleague. Just too large for a DVD and he doesn't have tape capability.
Thanks,
Craig

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Balaji Thiruvenkataraju Newbie Points: 4 More actions · Answer 1

Hi Craig,

The best way to split the large backup files, is using SQL stripped backups.

Thanks

Balaji

peterhe SSChampion Points: 11469 More actions · Answer 2

You can backup the database to multiple devices like:

BACKUP DATABASE YourDBTO DISK='C:\backupfile1', DISK='C:\backupfile2',...

You can have at most 64 files.

C Schaefer SSC-Addicted Points: 415 More actions · Answer 3

Thanks folks,

I ended up using a file splitter program to split the backup file into pieces and let them reassemble it on the other end.

David A. Long SSCrazy Eights Points: 8421 More actions · Answer 4

You can split one file with ZIP and it will prompt for the chain to restore.

Can you say floppy diskette, good thing in those days we were only worried about a 500MB file, now that was a pile of floppies. Disk copied them to boot and was I glad when one was bad the other worked just fine.

Andy

Bill Scott SSCrazy Points: 2338 More actions · Answer 5

Very Cool! How do you control the size of the files created by the backup process? Is there a way to specify the backup file size or do I do that by sizing my partitions? I didn't see an option for size in BOL for 2K.