URGENT!!! Database need recovery

Question

URGENT!!! Database need recovery

halifaxdal

SSCoach

Points: 19741
More actions
October 26, 2006 at 8:22 am

#170256

Please don't ask why and how this happened.
I detached a database on server1 and attached with another file from server2, so the data on server1 is gone. There is no backup plan on server1.
Is it possible to get data back?

Thank you for any clue.

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

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

MenTaT :-) SSC Eights! Points: 811 More actions · Answer 1

If you did not delete the MDB file you should be able to re_attach as either the same DB name or another name and retrieve the data.

--Ron

halifaxdal SSCoach Points: 19741 More actions · Answer 2

Thanks for your quick response.

When I attached the database file, I assume the old one was replaced by the new one. Do you mean the old one still exists somewhere in the disk?

MenTaT :-) SSC Eights! Points: 811 More actions · Answer 3

Yes.

It should be in the data folder of the path in which the sqlserver was installed to.

--Ron

halifaxdal SSCoach Points: 19741 More actions · Answer 4

Are you sure?

For example, usually the database mdf files is in C:\Program Files\Microsoft SQL Server\MSSQL\Data, how would you get it back? Remember I said the database was detached, and then attached with another file from another server.

THANKS.

MenTaT :-) SSC Eights! Points: 811 More actions · Answer 5

Was the other file the same name?

Did you copy the file to the folder

C:\Program Files\Microsoft SQL Server\MSSQL\Data ??

When you attached the other file, Did you just attach from it's original location???

--Ron

halifaxdal SSCoach Points: 19741 More actions · Answer 6

The very bad thing is the file was copied from somewhere else into that folder and over ride the original one.

MenTaT :-) SSC Eights! Points: 811 More actions · Answer 7

MenTaT :-)

SSC Eights!

Points: 811

October 26, 2006 at 9:08 am

#668235

--Ron

Ian Goethert Say Hey Kid Points: 691 More actions · Answer 8

Is there any chance you have shadow copy running on the server?

http://www.microsoft.com/windowsserver2003/techinfo/overview/scr.mspx

halifaxdal SSCoach Points: 19741 More actions · Answer 9

No luck, hope is fading.... mdf/ldf are over written, ...

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 10

Basic answer. Overwritten file + new file in use = you better have another copy. Sorry but there's nothing anyone can do on this one.

debrucer1 SSCertifiable Points: 5366 More actions · Answer 11

you know, even with the file "overwritten"... if you STOP what you are doing IMMEDIATELY and stop ALL other activity on the box, you MAY have been able to "undelete" the "overwritten" file on the disk.

Now, I really suspect it is too late this time, just based on what is being said in this thread... but a "deleted" file is not deleted from the disk, only made "not visible"... and when you "overwrite" a file, you do not necessarily overwrite it, unless you have software that intentionally does so.

But, I still agree with Ninja's response... probably "nothing anyone can do"... at this time.

sucks! (maybe worse... keep your resume updated).

and good luck!

Thank-you,
David Russell
Any Cloud, Any Database, Oracle since 1982

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 12

His best and almost only chance is to have the file in the recycle bin. Other than that I would be very surprised that no sector were affected by the overwrite and day to day db activity. But I hope I'm wrong.