November 25, 2008 at 2:10 am
Can I rebuild MDF file from LDF file. I used SQL 2005 no backup.
November 25, 2008 at 2:29 am
No - in any practical situation this would be impossible
November 25, 2008 at 2:37 am
As Tom already said the answer is no. The ldf file only contains the transactions since the last tlog backup, but not the data.
You need to restorew from backup, if you have one.
[font="Verdana"]Markus Bohse[/font]
November 25, 2008 at 2:39 am
Thank you Tom Brown.
Can you suggest me for this problem ,because my data is very important
November 25, 2008 at 2:45 am
Thank you Markus
I no have backup.
November 25, 2008 at 2:54 am
supatpong (11/25/2008)
Thank you Tom Brown.Can you suggest me for this problem ,because my data is very important
If your data is very important, why don't you have a backup?
[font="Verdana"]Markus Bohse[/font]
November 25, 2008 at 3:00 am
You need to find another way to get your data back. The LDF file alone will not work.
Either an older backup if you have one or, if its a broken hard disk a specialist who can try to recover the data - however such services can be expensive.
I'm sorry - but this is the way it is. We all lose important data sometimes.
November 25, 2008 at 3:00 am
Tom Brown (11/25/2008)
No - in any practical situation this would be impossible
yes practically it is impossible as it contains the transaction information only. but depending on the required information, data can be search in chunks, by using third party tool
kshitij kumar
kshitij@krayknot.com
www.krayknot.com
November 25, 2008 at 3:12 am
Thank you for many support. Now I trying to find software tool.
November 25, 2008 at 5:44 am
"Now I trying to find software tool."
There is no software tool that will do what you want. What the previous posts have been trying to explain is that there is not enough information in the log file to rebuild a data file.
It is time to go to the boss and let them know the data is gone.
November 25, 2008 at 11:06 am
supatpong (11/25/2008)
Thank you for many support. Now I trying to find software tool.
Don't bother. All the log reader tools need the database to be online. Besides, all that you'll be able to get from the tran log is a few minutes or so of data changes, not the data.
No mdf and no backup means you do not have a database. There is no way that it's coming back.
Why do you not have a backup for an important database?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 25, 2008 at 12:04 pm
Toooo bad... at least one backup you should have or copy of that DB! - :w00t:
Try to restore the files with other application for restoring maybe you can find something but be sure that you didn't format the drive where has been your mdf file!
November 26, 2008 at 6:43 pm
have a drink...then book a flight to the Cayman Islands
November 27, 2008 at 3:28 am
As others have said, no backup means the ldf file is useless.
You're going to have to get the database back via a 3rd party who specialise in data recovery. Even if the drive has been formatted or physically damaged there are companies out there who can help.
However, it will be expensive.
December 5, 2008 at 1:47 pm
Ok, here's a hypothetical. What if:
a) Recovery model was set to Full
b) No database backups were ever done
c) No transaction backups were ever done
d) No activity was performed in the database that didn't get logged in transaction log
e) Not other activity caused the transaction log to be truncated
Wouldn't it be theoretically possible then that the database could be recovered? Of course as soon as one of the above was not true, this would be impossible. But since it sounds like there haven't ever been any backups..just maybe...
-cmw
Viewing 15 posts - 1 through 15 (of 40 total)
You must be logged in to reply to this topic. Login to reply