Locate the file that a given non-clustered index is stored on?

Asked Nov 24 '20 at 02:05

Active Nov 24 '20 at 02:05

Viewed 25 times

Is there a query to view which file a given non-clustered index is stored on?

asked Nov 24 '20 at 02:05

user2368632

Just taking a step back, what are you trying to solve by figuring this out? – J.D. Nov 24 '20 at 02:46
Are you talking file or filegroup? – Hannah Vernon Nov 24 '20 at 03:14
Saw a user screen shot of app error saying that index IX_FOO could not allocate space in database BAR. Trying to find the underlying file that is out of space. – user2368632 Nov 24 '20 at 04:51
1

Does this answer your question? Primary filegroup is full SQL Server 2008 the error message should indicate the file group you need to worry about-- PRIMARY or otherwise – AMtwo Nov 24 '20 at 05:12

0 Answers0