lidds Posted August 15, 2005 Posted August 15, 2005 I need all your expertise quite urgently. I stupidly last night deleted my db .ldf file (can't get the one I deleted back at all) and obviously now I can't attach my .mdf file as it giving errors saying that it can't find the relevant .ldf file :( (don't 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 Quote
Joe Mamma Posted August 15, 2005 Posted August 15, 2005 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 Quote Joe Mamma Amendment 4: The right of the people to be secure in their persons, houses, papers, and effects, against unreasonable searches and seizures, shall not be violated, and no warrants shall issue, but upon probable cause, supported by oath or affirmation, and particularly describing the place to be searched, and the persons or things to be seized. Amendment 9: The enumeration in the Constitution, of certain rights, shall not be construed to deny or disparage others retained by the people.
lidds Posted August 15, 2005 Author Posted August 15, 2005 I don't know what I did, but ended up doing restore, learnt my lesson, back-up a lot more. Thanks anyway Simon Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.