November 6, 2008 at 5:49 am
We're replacing all our drives on one of our servers and I'm trying to move all database files off of the current drive. I've detached, copied, and attached successfully for ALL the databases listed in MS. for some reason I have 2 ldf files that can't move becuase they are being used by another process. Is there an easy way to figure out what Database these specific files are attached to? I ran against sysfiles and it shows the database files fo rthe database you are in, but because I can't find the database, sysfiles is useless.
November 6, 2008 at 5:57 am
select * from master..sysaltfiles
Wilfred
The best things in life are the simple things
November 6, 2008 at 6:06 am
SELECT * FROM sys.master_files
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply