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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2008-07-01 : 08:18:19
|
| Hi,How can I achieve the following in sql?Verify F drive is on disk 0 (Separate from G drive on disk 1)Thanks |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2008-07-01 : 12:59:14
|
| If I'm reading your question correctly, you want to know if the two logical drives are on the same spindle (physical drive). While there are some system tables that hold disk information (e.g., sys.database_files, sys.master_files), I don't think that they will hold the type of information that you are looking for. The actual drive configuration is a physical implementation detail and the SQL engine doesn't concern itself with the physical implementation.Having said that, you may be able to capture the physical drive layout and store it in a table. From there you should be able to map the physical to the logical and extract the information you want.=======================================Some people walk in the rain, others just get wet. -Roger Miller, musician (1936-1992) |
 |
|
|
|
|
|
sql-drive