backup log with NORECOVERY | STANDBY

• hl6a

  Ten Centuries

  Points: 1004

  More actions

  August 22, 2008 at 9:53 am

  #123050

  Have you ever used ‘back up log with NORECOVERY | STANDBY’?

  Could you give me some scenarios/examples that use NORECOVERY or STANDBY? What do you ususally do next? This would help me understand these two options and the third one 'NO_TRUNCATE'.

  Thank you!

• JamieX

  Hall of Fame

  Points: 3763

  More actions

  August 22, 2008 at 9:59 am

  #862020

  -- and i just realized I didn't answer your question whatsoever. Talking about restores 🙂

  check this article

  http://www.karaszi.com/SQLServer/info_restore_no_truncate.asp