Post reply

Whats are the Advantages of Filegroups in Sql Server 2005

  • July 31, 2008 at 4:59 am

    #851155

    zafar (7/31/2008)

    I am already using the schema's to group the tables domain wise,

    so what the filegroup does ??

    as someone said here that you will yous for the large database environment!

    :hehe:

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • July 31, 2008 at 5:00 am

    #851156

    Maybe many of them... the first one is when you have the large database environment you will do some partition data in many data files so this partition is possible when you creating more filegroups!

    The second is putting the SQL Server 2005 objects in different filegroup for administrative purposes this is often necessary when you have again very large database and you are running into difficulty meeting your recovery requirements!

    this is posted in your second same post

    😎

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

Viewing 2 posts - 16 through 16 (of 16 total)

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