The database file was deleted by mistake! Hundreds of thousands are in a hurry, asking for help!

kxiaper

If there is no way, the landlord can try to find a normal mdf / ldf file, first backup the damaged mdf / ldf file,
Then use UltraEdit to open the normal and damaged mdf / ldf files respectively, compare the difference between the file header / file end,
Then make the corresponding changes :)

danielcui

Now the file header is damaged

恶魔右指

There is a situation where such a situation occurs, that is, the landlord deletes the file added to the drive letter of the database and destroys the track.
You can try to use the statement to fix it, and there is no better way.
Even tested to delete more than 2G database, the restored database is no problem

sayiken

The upstairs attention is good, you can try, but the larger one is not easy to say ...

wudi1982

The lesson of blood, another person died!

torechary

There seems to be software on the Internet that can recover hard disk data ~
Last time someone seemed to tell me ~
Dude ~
Go online

噼里啪啦

my condolences

lancer06

The best way is to back up every day ~~

adonisye

Hard disk recovery expert, give money, depending on the specific situation, if the data is important and there is low loss, hundreds of dollars

821105

The database file generally has two files (MDF / LDF, data file and log file), have you all recovered

Before data recovery, have you written data to the hard disk partition where the original database file was stored (such as creating a file / creating a new database ...); if the above operation is performed, some data may be destroyed and the database may not restore

If the above problems do not exist, that is to say, you feel that the restored database file is intact, and it is good not to operate on this machine. You can restore the database on another computer, as long as you use SQL append to complete.
This is mainly to avoid destroying the data on the original hard disk when restoring the database.Once the database file restored by the tool has a problem, it is difficult to complete the restoration.