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 |
|
shiloh
Starting Member
48 Posts |
 Posted - 2007-06-20 : 12:04:13
|
| Hi allLets say TableA is allocated to FileGroupA. And FileGroupA is allocated to 2 drives. Is there a way to find out on which drive exactly is the data on. I am thinking its not possible because SQL allocates both drives to the table and it decides how to spread the data. But just for the sake of it, can we find out if the TableA, even though is allocated to both the drives, is actually on only one drive? Thanks,Don |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-20 : 14:02:17
|
| No you can't. |
 |
|
|
shiloh
Starting Member
48 Posts |
Posted - 2007-06-21 : 14:41:07
|
| hmm..thats what I thought too.. thanks for the confirmation. |
|
|
|
|
|
|
Can we find the actual physical drive table