Post reply

Can we put ldf file in different file group

  • June 4, 2009 at 12:16 am

    #138365

    Can we put ldf file in different file group

  • June 4, 2009 at 12:40 am

    #1004434

    ldfs(log files) aren't in filegroups. Only data files (mdf, ndf) can be part of filegroups.

    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

  • June 4, 2009 at 1:14 am

    #1004445

    Hi,

    Gilan is right Log files are not part of any filegroup.

    A small test. If you try to add a new file in thru SSMS you will see that for Log File under FIlegroup it will say "NOT APPLICABLE".

    Regards

    GURSETHI

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

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