backup

• ramyours2003

  SSChampion

  Points: 12268

  More actions

  March 24, 2013 at 11:52 pm

  #270366

  I have transactions 1,2 ,3 and 4 .

  1,2 are committed and the rest are uncomitted , when i take t-log backup whether all transactions are recorded in t-log or else only the 1&2 are recorded ?

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  March 25, 2013 at 12:55 am

  #1600185

  All of them.

  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

• ramyours2003

  SSChampion

  Points: 12268

  More actions

  March 25, 2013 at 1:03 am

  #1600186

  can u pls explain ?

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  March 25, 2013 at 1:12 am

  #1600188

  What is there to explain? You asked whether the two uncommitted transactions would be backed up with the transaction log. The answer is yes, they will be.

  If you have further questions, please ask.

  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

• Grant Fritchey

  SSC Guru

  Points: 398979

  More actions

  March 25, 2013 at 3:33 am

  #1600203

  As Gail says, they'll be backed up. Then, when you go to restore, the part of the restore process known as recovery deals with uncommitted transactions, rolling them back as needed.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning