Post reply

Does SharePoint Products & Technologies do not support the use of multiple filegroups??

  • July 19, 2009 at 1:18 am

    #133094

    Hi,

    We are maintaining Share point databases in sql server 2005 enterprise edition 64 bit. From this link

    http://blogs.technet.com/wbaer/archive/2007/05/08/database-management-concepts-for-large-and-growing-content-databases.aspx, the author, Bill Baer saying that SharePoint Products & Technologies do not support the use of multiple filegroups

    SharePoint Products & Technologies do not support the use of multiple filegroups; therefore, SQL Server 2005 technologies including piecemeal restore cannot be leveraged on a content database

    But he explaining again that we can create multiple filegroups

    while Creating Data Files (SQL Server 2005):

    Specify a logical name for the new file and select the secondary file group from Filegroup group column to associate the new file with the secondary filegroup

    So I'm confused with this. One time he is saying SharePoint Products & Technologies do not support the use of multiple filegroups but later again he saying we can create.

    So please calrify me...

  • July 19, 2009 at 9:04 pm

    #1026694

    Hello DBAs, maintaining Sharepoint databases, please explain me that SharePoint Products & Technologies supports the use of multiple File groups are NOT??

  • July 24, 2009 at 1:13 am

    #1029496

    Could you please give me some info on this??

  • July 25, 2009 at 10:58 am

    #1030177

    Go through this link http://www.sqlskills.com/BLOGS/PAUL/category/Sharepoint.aspx

    which says you can not create multiple filegroups for share point databases but you can create multiples files in a single filegroup.

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

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