Recover Lost or replaced database

(0) Share

Report

Posted on by Albert_

450

I have got in a big trouble ! I was trying to restore a database in an empty one. I put the restore files in D directory of Windows, then create a new empty database and tried to restore that files in the new db. But It seems I restored that files in our original crm365 database ! Now in the data directory of MSSQL; the actual .mdf and .ldf files of CRM365 do not exist and in MSSQL Server, when I right click on CRM365 and go to the properties tab, it points to the files in D directory! Is there anyway to get them back? Can I use recovery utilities? I did not create a backup recently and last accessible backup is about 20 days left!

Any help will appreciated !

All responses (5)

Answers (1)

Abigail 550 on at

Like (0)

Report

RE: Recover Lost or replaced database

The only solution is the backup that you have which is 20 days old.

It'll help you to recover as much as is possible.
Albert_ 450 on at

Like (0)

Report

RE: Recover Lost or replaced database

Actually the DB Server is a VM and my backup is a snapshot of the VM !

It seems I have to restore the VM.
a33ik 84,323 Most Valuable Professional on at

Like (2)

Report

RE: Recover Lost or replaced database

Albert,

That's what I meant. I'm afraid you lost data for those 20 days.

Any chance you backed up your server if it is virtual?
Albert_ 450 on at

Like (0)

Report

RE: Recover Lost or replaced database

You mean there is no way?

My backup is about 20 days left and it means 20 days of data has lost.
Verified answer

a33ik 84,323 Most Valuable Professional on at

Like (2)

Report

RE: Recover Lost or replaced database

Hello,

I'm afraid that the backup you have is your best choice.