backup log

• ramyours2003

  SSChampion

  Points: 12268

  More actions

  May 28, 2013 at 12:01 am

  #278237

  is it possible to take log backup in a restored database ?

• Oliiii

  SSCertifiable

  Points: 5328

  More actions

  May 28, 2013 at 12:15 am

  #1618857

  Yes, as long as the database is in full recovery mode.

  See here for more info: http://msdn.microsoft.com/en-us/library/ms186865(v=sql.105).aspx