Post reply

Filegroup

  • July 11, 2013 at 3:39 am

    #279890

    Hi All,

    Please let me know whether it is possible to use the same secondary filegroup for 2 different databases.

    I tried manually and it did not allow.Just wanted to confirm the same.

  • July 11, 2013 at 3:47 am

    #1631507

    The actual same filegroup? No, it's not. A filegroup with the same name? Yes, it is.

    John

  • July 11, 2013 at 5:47 am

    #1631529

    kk.86manu (7/11/2013)

    Hi All,

    Please let me know whether it is possible to use the same secondary filegroup for 2 different databases.

    I tried manually and it did not allow.Just wanted to confirm the same.

    Filegroups are logical entities while files are physical entities. Why do you want to do this?

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]

  • July 14, 2013 at 12:06 am

    #1632210

    I have added the new file group called Secondary in one database and i have added one file in that file group.

    I have done the same in another database.

    By this we can say it allowed same file group for 2 databases.

    Thanks,
    I’m nobody but still I’m somebody to someone………….

  • July 14, 2013 at 5:23 am

    #1632220

    sweetmoulali (7/14/2013)

    IBy this we can say it allowed same file group for 2 databases.

    No, what you've done is add a filegroup to each database and given it the same name. It's not the same filegroup, it's two filegroups with the same name.

    Same filegroup would imply that the files in those filegroups were the same across the two databases and that's definitely not possible.

    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

  • July 14, 2013 at 11:28 pm

    #1632295

    Thanks Shaw for the information. I understand your point on file groups and my misunderstanding.

    I would like to share one of my views on files i.e. same file (with same logical name) could not be added in 2 databases.

    Is that correct?

    Thanks,
    I’m nobody but still I’m somebody to someone………….

  • July 15, 2013 at 1:20 am

    #1632331

    sweetmoulali (7/14/2013)

    I would like to share one of my views on files i.e. same file (with same logical name) could not be added in 2 databases.

    Is that correct?

    Same logical name does not mean same file. I can have two completely different files in different databases with the same logical name. They're still two completely separate files they just have the same logical name.

    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

  • July 15, 2013 at 1:30 am

    #1632334

    Thanks Shaw for your input.

    Thanks,
    I’m nobody but still I’m somebody to someone………….

Viewing 8 posts - 1 through 7 (of 7 total)

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