Restore database with transaction log backup

• nitinkumar_tss

  Old Hand

  Points: 331

  More actions

  September 13, 2010 at 2:47 am

  #140650

  Hi All,

  I have senario for restoring database, anyone please help me.

  I have only transaction log backup of a database, I don't have any full backup for that database. And the database is deleted. Now I have to restore the database from the transactoin log backup.

  Please suggest me how can I restore the database from the only transaction log backup I have.

  Thanks,

  Nitin Kumar

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  September 13, 2010 at 2:53 am

  #1219899

  You can't. To restore you need a full database backup. A transaction log backup does no contain the entire DB, it contains only the record of changes that occurred in the interval that the transaction log backup covers.

  No full backup = no restore possible.

  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

• homebrew01

  SSC Guru

  Points: 55548

  More actions

  September 13, 2010 at 4:51 am

  #1219948

  You could ask your network administrators if they took any backups, or even took backups of the disk where the database (.MDF) was. Maybe you will get lucky.

• SQLBuddy123

  One Orange Chip

  Points: 28294

  More actions

  September 13, 2010 at 2:34 pm

  #1220310

  Check with your windows admin to see you have any server level backups which could help you in restoring the db.

  If you have only log backup then there is no way in which you can restore the db.

  Thank You,

  Best regards,

  SQLBuddy