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 |
|
acko
Yak Posting Veteran
52 Posts |
 Posted - 2004-03-17 : 06:40:39
|
| HiI have a database with two datafiles, located on PRIMARY file group.The .mdf has 20gb, and .ndf has 5gb.How can i determine which tables are created on .mdf and which on .ndf data filethanksalex |
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-03-17 : 07:02:21
|
| You can't. If you have one filegroup the tables are created and written to across both your files. SQL Server writes the data evenly across the files. You can't allocate tables to specific files within a filegroup.If you are concerned about object placement, create a secondary filegroup and make it the Default then all your user data will be written there instead of the PRIMARY filegroup.Raymond |
 |
|
|
|
|
|
DataFiles