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.