December 28, 2005 at 9:40 pm
Hi,
I have accidentally deleted my .mdf database file...
I have a "4 months old" copy of this .mdf file..
Moreover I have the .ldf file of deleted .mdf.
.ldf file has a 500 MB size, so it most probably contains the whole transactions of last 4 months... (even more)
I think you have figured out the situation..
I have (old .mdf) and (new .ldf)..
What can I do?
( The files belogs to MS SQL (version) 2000... )
(Currently I have installed MS SQL 2005 in my machine...)
* Could you please comment your suggestion with a detailed explanations since I am not a db admin...
Thank you so much...
December 29, 2005 at 6:54 am
Do you have a .bak file anywhere?
We you running in simple or full mode ?
Mike
December 29, 2005 at 9:25 am
I have no .bak file...
I am not sure about Simple/Full Mode. Could you please try to figure out your solution for both of them if you have?
Thanks.
December 29, 2005 at 11:32 am
You can not use a recent .ldf with an old .mdf. SQL Server knows they don't go togther and will give you errors.
You are going to be out of luck with this one.
As for the SIMPLE/FULL mode...I'm not sure what the other poster meant by asking that as it doesn't really apply. All it deals with is what types of backups you can do. SIMPLE mode does not allow Transaction Log backups. Full mode does.
-SQLBill
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply