what is inside xxx.ndf - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

what is inside xxx.ndf

Author

Topic

yhchan2005
Starting Member

26 Posts

Posted - 2010-06-07 : 00:32:36

Hi,

i have 1 DB which created by my x collegue which was resign. i found out beside the .mdf and .ldf file, the same db also got 2 .ndf as below

xxx_Attachment.ndf
xxx_History.ndf

how can i check what is inside this 2 file or which table / index is using above 2 .ndf file. notice that this 2 file size is increasing.
Please help !!

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-06-07 : 01:14:45

Check the database in SQL, is there one filegroup or multiple filegroups?

--
Gail Shaw
SQL Server MVP

yhchan2005
Starting Member

26 Posts

Posted - 2010-06-07 : 02:18:18

it is multiple file group. but have check the xxx_History is in the Primary filegroup and xxx_Attachment is in Attachment file group. I am not sure what is inside xxx_History ??? any SQL command to check ?

ratheeshknair
Posting Yak Master

129 Posts

Posted - 2010-06-07 : 06:46:34

Try this

SELECT

fg.data_space_id, fg.name,

ObjectName = OBJECT_NAME(p.object_id), p.index_id

,df.name, df.physical_name, [Size] = df.size*8/1024

FROM sys.filegroups fg

LEFT JOIN sys.database_files df

ON fg.data_space_id = df.data_space_id

LEFT JOIN sys.partitions p

ON fg.data_space_id = p.partition_number

WHERE (p.object_id>4096 or p.object_id IS NULL)

RKNAIR

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources