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 |
|
darkmagician
Starting Member
1 Post |
 Posted - 2007-10-26 : 04:48:52
|
| hi all,Sorry this question may sound silly to anyone of you, but I just wondering:One of my databases is having 3 data files, and I notice that the sizes of these 3 data files are quite unevenly distributed. the mdf one is around 35%-40% larger than the second data file, whereas third data file is also 20-25% larger than the second data file. What could have result it? Does anyone know? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-26 : 11:29:22
|
| The difference is due to the objects that you have placed in the files.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-27 : 01:44:00
|
| Are they in same file group? By the way, all system objects are in .mdf file. |
|
|
|
|
|
|
Data files size uneven