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: 730281

  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

  Follow me on Twitter: http://www.twitter.com/way0utwest
  Forum Etiquette: How to post data/code on a forum to get the best help
  My Blog: www.voiceofthedba.com