Deleted db .ldf file - STUPID ME...

L

lidds

Well-known member
Joined
Nov 9, 2004
Messages
210
I need all your expertise quite urgently.

I stupidly last night deleted my db .ldf file (cant get the one I deleted back at all) and obviously now I cant attach my .mdf file as it giving errors saying that it cant find the relevant .ldf file :( (dont know exact error as I am not at my computer).

I have tried sp_attach_db with only specifying the mdf file, I have also tried sp_attach_single_file_db, and also tried creating a new db with the same name and then replacing the new .mdf file with my old one, but again with no joy.

Is there some way that I can overcome this, telling Enterprise Manager to ignore the .ldf completely and create a new one.

I have got a backup on CD but was from 2 days ago and I have done quite a bit on the db since then, so am trying all other options before resorting to this.

Any help would be great.

Thanks

Simon
 
I have never had this problem before, unless, there was an existing .ldf file in the old file path of the .mdf.

If I use enterprise manager, and no exisiting ldf file is found, I get a warning but a new ldf is created
 
I dont know what I did, but ended up doing restore, learnt my lesson, back-up a lot more.

Thanks anyway

Simon
 
Back
Top