Rogue MDF and LDF file

Question

Rogue MDF and LDF file

jayoub

SSCertifiable

Points: 6991
More actions
January 17, 2014 at 9:44 am

#396122

I have an MDF and LDF file giving me trouble. When i try to copy and paste the file i get Cannot copy Filename: Access Denied, make sure disk is not full or write protected...
Specs:
Windows Server 2003
Microsoft SQL Server 2005 - 9.00.5000.00 (X64) Standard Edition (64-bit) NT 5.2 (Build 3790: Service Pack 2)
2 node Cluster Active Active (two nodes with an instance on each node)
Problem: I am trying to archive this MDF and LDF files on one of the clustered resources (Physical Disk) and I cannot move the file
I ran SELECT DB_NAME(database_id), physical_name FROM sys.master_files and found that there are no databases attached to this file in the instance that is using this drive. Maybe another instance is using that drive, but do not know.
I tried to take ownership of the file (No Go)
I tried to attach it to an instance and the MDF file does not even show up to be attached even if i select "All Files" the LDF file shows, but not the MDF file
I even took the Clustergroup Offline and still could not move the file
I did not stop the SQL Service and try and maybe that would be the trick.
What can i do to break into this file? I would like to get the file archived before I remove the disk
Please let me know and your help is appreciated.
Jeff

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 1

Jeff

If the file is being used by another instance, that instance is going to be on the same computer. Are you able to see whether any other instances are running on the computer or cluster?

John

HanShi SSC-Dedicated Points: 33507 More actions · Answer 2

If you can't figure it out (you don't know which instances are installed or don't have access) you could use ProcessExplorer from Sysinternals to see which process is locking the files.

** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

jayoub SSCertifiable Points: 6991 More actions · Answer 3

There is only one instance on that node and an instance on node 2 and neither are showing that database.

Jeff

jayoub SSCertifiable Points: 6991 More actions · Answer 4

I solved the issue.

I ended up taking ownership of the file and then adding myself with full control (which i did not do before) and was then able to Archive the files.

Thanks for the help

Jeff