sql server database creation from ldf (Log Transaction File)

• amjadalimcs_pk

  SSC Rookie

  Points: 38

  More actions

  March 9, 2016 at 10:42 pm

  #316711

  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

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  March 10, 2016 at 1:11 am

  #1864180

  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

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  March 10, 2016 at 3:02 am

  #1864189

  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

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass