March 3, 2010 at 12:35 pm
Hello,
I have accidentally deleted deleted .mdf, .ldf, and .ndf files to a very important db and would like some recommendations on any recovery tool that anyone has used to successfully recover the files. Help would be greatly appreciated ASAP. Thanks.
March 3, 2010 at 12:44 pm
Since it's an important database, wouldn't it have a backup?
You can try any disk undelete tool, providing absolutely no changes have been made to the disk since the files were deleted. Your chances however are not very good for recovering deleted database files.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 3, 2010 at 12:44 pm
I hope you have current backups. IIRC, the waste basket on Server may not be big enough to allow you to recover the database files like you would other files.
March 4, 2010 at 5:43 am
Lynn Pettis (3/3/2010)
I hope you have current backups. IIRC, the waste basket on Server may not be big enough to allow you to recover the database files like you would other files.
I thought it was off by default on Servers?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 4, 2010 at 7:18 am
Apparently not on my servers. Any time I delete files it asks if I'm sure I want to move them to the trash can. I think it depends how big the files are.
March 4, 2010 at 7:23 am
I think you should take help of some OS/Computer guy who can help you in knowing whether files can be obtained back.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply