Post reply

Filegroups in Sql Server 2005

  • July 29, 2008 at 5:36 am

    #125324

    Whats are the Advantages of Filegroups in Sql Server 2005

  • July 29, 2008 at 6:21 am

    #849715

    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!

    😎

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

  • July 29, 2008 at 6:59 am

    #849738

    filegroups offer managability but more over performance. They are primarily designed to be spread across disks\arrays and unless doing so are not going to be of any benefit to be honest with you

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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