Home Forums SQL Server 2008 SQL Server 2008 Administration #Files and FILEGROUPS RE: #Files and FILEGROUPS

  • March 7, 2013 at 9:59 am

    #1594550

    GilaMonster (3/7/2013)

    The one file/ x cores is for TempDB, not for user databases.

    Unless you have reason to split a user database for recoverability or IO issues, you probably don't want to split it.

    Thanks,

    If there are IO issues should the new ndf file be on the same RAID or a different, probably new one (since the IO is on the RAID adding the new file to the existing RAID won't make a difference.. or will it?!)?

    And are my thoughts on FILEGROUPS correct?

    They are useful to "split" data for backup/restore issues?

    I can create an INDEX FILEGROUP to store the index and not make a backup on the index data and if I need to restore the database I'll just recreate the indexes since I have the DDL.

    Thanks,

    Pedro


    If you need to work better, try working less...