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.
| Author |
Topic |
|
hannah00
Starting Member
31 Posts |
 Posted - 2008-01-07 : 11:17:30
|
| we have a file group that contains of three datafiles, but for some reasons, SQL only used the PRIMARY datafiles and the other two are not being used. what command do I need to run in order for SQL to use all three datafiles are any given time?thanks |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-01-07 : 11:59:21
|
| You have to create tables, constraints, or indexes in the other filegroups.CODO ERGO SUM |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-07 : 22:37:07
|
| Sql should use all files in the group. Are you sure they are in same file group? |
|
|
|
hannah00
Starting Member
31 Posts |
Posted - 2008-01-09 : 13:01:36
|
| I think Michael is right, In fact this is what I found out:1. create the first filegroup and put the primiary in there so that all of the system tables goes in there.2. create another filesgroup with more than 2 datafiles and for SQL to use the second filesgroup so that all of the files are being used.Please correct me if I ma wrong. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-09 : 23:12:39
|
| You can put all files in file group, even don't need multiple files. |
|
|
|
|
|
|
Files Group usage