Recovery Scenarios

• Torrance Barnum

  Newbie

  Points: 1

  More actions

  August 4, 2004 at 9:04 am

  #152252

  Greetings,

  Does anyone have some illustrations of recovery scenarios when media failure, and server crashes suddenly occur? My other scenario question is how does SQL Server handle torn pages in a database if media failure or server crashes occur whether you have torn pages detection on or off?

   

  T

  Atlanta, Ga

• Steve Jones - SSC Editor

  SSC Guru

  Points: 732663

  More actions

  August 4, 2004 at 11:25 am

  #517688

  I'm not sure what you mean. Do you mean physical illustrations or txt examples? There are a few articles on the site dealing wiht this.

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

  http://www.sqlservercentral.com/columnists/awarren/disasterintherealworld2.asp

  http://www.sqlservercentral.com/columnists/bahmed/backupscenariosforsuccessfulsqlserverrestoresandre.asp