Database recovery

Question

Post reply

Database recovery

sharathgt

SSC Enthusiast

Points: 123
More actions
October 3, 2023 at 6:39 am

#4300174

Hi,
My .mdf file is accidentally deleted at client's place and without bothering the system is also being used for more than a week. So system file recovery was not successful. I do have log (.ldf) file. can we recover data from the .ldf file... I do have the schema script if that helps. Backup files are also not available.
Please suggest.
Thanks & Regards,
Sharath
October 6, 2023 at 9:35 am

This was removed by the editor as SPAM
October 6, 2023 at 9:44 am

This was removed by the editor as SPAM
January 11, 2024 at 10:32 am

This was removed by the editor as SPAM
January 13, 2024 at 12:20 pm

This was removed by the editor as SPAM
January 30, 2024 at 7:37 pm

This was removed by the editor as SPAM
January 31, 2024 at 12:46 pm

This was removed by the editor as SPAM
May 24, 2024 at 5:54 am

This was removed by the editor as SPAM

Viewing 12 posts - 1 through 11 (of 11 total)

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

Ant-Green SSC Guru Points: 113507 More actions · Answer 1

No you need to MDF and LDF or a backup.

You will need to create a blank DB using the schema script, but all your data is lost.

Michael L John One Orange Chip Points: 27060 More actions · Answer 2

sharathgt wrote:

Hi,
My .mdf file is accidentally deleted at client's place and without bothering the system is also being used for more than a week. So system file recovery was not successful. I do have log (.ldf) file. can we recover data from the .ldf file... I do have the schema script if that helps. Backup files are also not available.
Please suggest.
Thanks & Regards,
Sharath

This makes no sense. The only way an .mdf file could have been deleted would be if the SQL Server service was shut off or if the database was detached. You would have received an error that the file was in use otherwise.

Does the database appear in SSMS? If you right click on "Databases" in SSMS, "Attach" should appear. Does it show up in there???

This reply was modified 1 year, 2 months ago by Michael L John.

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

sharathgt SSC Enthusiast Points: 123 More actions · Answer 3

SSMS do show the DB without giving any access to it when we click on it... It says .mdf is missing.

As I said, the DB resides in a client PC. So I really do not have control over that. So no error, nothing is observed and the client is not so literate about any such things...

True that server must be off or the DB must be offline for file deletion... but don't know much about this... I doubt some foul play...

We did all physical data recovery using few recovery software but no luck...

My only choice was " If I can recover data from an LDF file to an empty schema "... If it's a Definitely "No".. then I will move on...

Thanks much for the time...

This reply was modified 1 year, 2 months ago by sharathgt.

Jeff Moden SSC Guru Points: 1004412 More actions · Answer 4

It sounds to me like someone may have tried to move the database files and failed to do it correctly. The MDF file may still exist someone on one of the drives the server used. If you can find it, come back and we'll tell you the steps to "reattach" the database.

If you can't find it, you'll need to restore it from backups. I don't need to tell you what will happen if backups weren't happening in an automatic fashion.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)