Restore backup without log file

• smv929

  SSCrazy

  Points: 2889

  More actions

  July 15, 2002 at 11:36 am

  #157878

  We need to restore a backup in which the log file is huge. Is it possible to restore from a backup without restoring the log file?

  
  smv929

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736642

  More actions

  July 15, 2002 at 12:58 pm

  #432739

  When you restore from a backup, you do not restore the log. If you create a new database with a smaller log, you can restore into this.

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones