Post reply

Creating Backup - An error

  • January 17, 2006 at 6:48 pm

    #166781

    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!

     

     

    Regards,

    Timber

  • January 18, 2006 at 3:21 am

    #615408

    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

    #615475

    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..

     

    Regards,

    Timber

Viewing 3 posts - 1 through 2 (of 2 total)

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