Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

share|improve this question

1 Answer 1

up vote 1 down vote accepted

No you can't. All you can do is change the maintenance plan to use a different filename for each backup, then after a couple of days delete the stupidly large file.

share|improve this answer
    
+1 For telling me what I didn't want to hear! Sadly, as a business, we have to be in a position to roll back to a point in time in our data. Our internal application does not audit changes to the database (it would have if I had written it!). I will need to store this large file for a number of years. I do accept this is likely the one and only answer, but I'll leave this open for a short while. –  iWeasel Oct 10 '12 at 11:53
1  
I'd compress the file (it'll compress pretty well) and burn it to a couple of DVDs just to be safe so that you don't have to worry about it. –  mrdenny Oct 10 '12 at 18:20

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.