March 9, 2016 at 10:42 pm
I have just ldf file (log transaction file) and there is no data file & any other backup file. Is it possible that I may create a database from this log transaction file. Kindly give me a complete solution for this issue.
Thanks in advance
March 10, 2016 at 1:11 am
No, I'm sorry. The log file is not enough to restore a database.
You need the data + log files to attach them (might or might not work depending on how the files were obtained) or a full database backup.
-- Gianluca Sartori
March 10, 2016 at 3:02 am
There is no solution to that. A log file is unlikely to contain all of the changes made back to the DB's creation, and you can't play it forward alone. You need a full backup to start any restore process.
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
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy