How to Simulate Page Corruption.

• Mr.SQL DBA

  SSC-Addicted

  Points: 496

  More actions

  May 7, 2011 at 2:44 am

  #250402

  Hi Experts,

  I am trying to simulate a Scenario as:

  You have a database on a RAID array that failed and has zero'd out a page. How can you get the data back?

  I'm going to simulate our scenario by shutting down the database and using a hex editor to zero out page 158 of the database. (This translates to byte offset 1294336 of the file being zero'd for 8192 bytes).

  Ref: http://blogs.msdn.com/b/sqlserverstorageengine/archive/2007/01/18/fixing-damaged-pages-using-page-restore-or-manual-inserts.aspx

  I want to corrupt the page manually and want to restore the page from restore page option from the latest backup to get the data back in the testing environment. I want some information that.

  1)How can we view the data page

  2)How can we edit that page using Hex editor(I am having Hex Editor Neo Software Installed)

  3)More Suggestions.

  Thanking you in Advance

  Jags.

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  May 13, 2011 at 7:34 am

  #1324287

  The following articles may be a start:

  http://sqlserverpedia.com/blog/sql-server-bloggers/corrupting-databases-for-dummies-hex-editor-edition/

  http://blogs.msdn.com/b/sqlserverstorageengine/archive/2007/01/18/fixing-damaged-pages-using-page-restore-or-manual-inserts.aspx

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/