Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 When to make filegroups

Author  Topic 

sagitariusmzi
Posting Yak Master

113 Posts

Posted - 2009-07-22 : 01:37:19

Hi,

I have a Database with only .mdf and .ldf files, The DB is about 4 GB in size. i was thinking about making new filegroups in the Database, But on which basis i should decide that ?


Regards

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-07-22 : 13:17:58
See here:
http://www.mssqltips.com/tip.asp?tip=1112
and here:
http://weblogs.sqlteam.com/dang/archive/2008/08/01/Are-you-a-DBA-Monkey.aspx


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-07-24 : 22:11:03
When you want to reduce I/O contention issue by spreading multiple FGs accross multiple disks.
Go to Top of Page
   

- Advertisement -