Use the following steps to find the physical devices on which a database resides:
Find the dbid of the database in sysdatabases.
For that dbid, select from sysusages to list all of the device fragments belonging to that database.
Using sysdevices, determine which device has a low through high virtual page range that includes the vstarts from step 2. The device fragment whose vstart you used is on that device.
