Post reply

Simple NEWB question. When doing backup, TRANS_LOG & FILEGROUP greyed out

  • August 8, 2008 at 8:52 am

    #190801

    When doing a backup of some of my SQL Server Databases, I noticed that some have the options of TRANSACTION_LOG and FILE and Filegroup greyed out. Changing from simple to full backup mode doesn't change this option. What causes one to allow transaction log backups and another not to?

    Thanks

    Bob

    Bob
    Not a downstroke, fistpicker

  • August 8, 2008 at 9:21 am

    #855303

    When you are in full recovery mode, you can do log backups.

    I think you have to have made at least one full backup for a filegroup backup, but I'd have to experiment.

  • August 8, 2008 at 9:22 am

    #855306

    Files and filegroup backups will not be allowed if you only have one file or filegroup.

    To enable log backups you'll have to switch to full recovery and take a full or differential backup. The full or diff then becomes the base for the log chain.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 8, 2008 at 12:17 pm

    #855440

    Thank you very much! Clear, and it did the trick.

    Bob
    Not a downstroke, fistpicker

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

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