jpomfret7 (1/10/2012)
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
And does that drive letter and file path still exist? I have to ask... 🙂
Jared
CE - Microsoft