recovery model

• ramyours2003

  SSChampion

  Points: 12268

  More actions

  November 5, 2012 at 8:37 am

  #393537

  this is always conmfusing me what are the differences between Bulk and simple recovery model ?

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  November 5, 2012 at 8:39 am

  #1556091

  MSDN - Recovery Models (SQL Server)

• George M Parker

  SSCertifiable

  Points: 5412

  More actions

  November 5, 2012 at 8:46 am

  #1556095

  Another good resource regarding a couple of misconceptions about the Bulk-Logged recovery model:

  http://www.sqlskills.com/blogs/paul/post/A-SQL-Server-DBA-myth-a-day-(2830)-BULK_LOGGED-recovery-model.aspx

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  November 5, 2012 at 12:42 pm

  #1556185

  http://www.sqlservercentral.com/articles/Administration/75461/

  http://www.sqlservercentral.com/articles/Recovery+models/89664/

  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