• Running SELECT * FROM test.dbo.sysfiles I got the following

    [/code

    fileidgroupidsizemaxsizegrowthstatusperfnamefilename

    116705152-1020test_dataJ:\SQLdata\test_data.mdf

    201280415-164000660test_logH:\SQLLog\test_log.ldf

    32823280-16400020test_indexG:\SQLIndex\test_index.mdf

    411363672-16400020test_data1P:\SQLData\test_data1.ndf