1

Can I split open/divide a large MS SQL disk media set?

view story
linux-howto

http://serverfault.com – MSSQL 2005 An old maintenance plan was backing up a database to a single disk based media set with append. It contains numerous full backups of about 2GB each. I now have a single media set file almost 0.5TB in size. Is it possible to easily split this media set into individual .bak files? I have now changed our maintenance plan to backup to individual files rather than a single disk device. This makes file transfer more manageable. (HowTos)