Post reply

How to enable file and filegroups in Backup component in sqlserver 2005 backup time

  • April 22, 2009 at 10:47 pm

    #384425

    Hi All,

    I want to try take a back up by clicking on back up wizard and i am trying to select file and filegroups option in Backup component tab, but it is not enabled for my data base. Any one can say how to enable that radio button in back up wizard, it's very urgent please help me. because my full back up mode is not working.

    Thanks,

    suresh

  • April 23, 2009 at 1:44 am

    #982688

    This behaviour is observed if the recovery mode of your database is SIMPLE instead of FULL. Try altering the database recovery mode to FULL and try the backup wizard.

    -Sat

    Cheer Satish 🙂

  • April 26, 2009 at 11:45 pm

    #984185

    Very Very thanks, i got solution by your great advise.

    Thanks again.

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

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