January 17, 2006 at 6:48 pm
We were trying to make a backup (using SQL EM) for one of our client's company database but we encountered an error saying
'Volume on Device [Pathname] is not part of a multiple family media set' Backup Terminating abnormally.
We did not know what to make of this. Thought and ideas are highly appreciated!
January 18, 2006 at 3:21 am
Is your device a disk or tape? If you have the space I would do it to disk.
If you are happy using SQL uin query anayzer try
BACKUP DATABASE <Your DB Name>
TO DISK = 'C:\Temp\Your DB Name.bak'
WITH STATS = 1
January 18, 2006 at 7:25 am
Thanks for the tip Allen. I went on and researched on the error and I believe this happens when backups are made on separate formats? (Like initially to a disk then you try to backup to a disk) I may have it all mixed up...
Anyway, Ima go ahead and try your suggestion using QA! Thanks again for all the help..
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply