Monthly Archives: May 2013

Mirroring suspends with Assertion error

Assume the following scenario: You are performing a Bulk Insert or BCP into a table of a database that is the principal in a database mirroring pair. The BCP or Bulk Insert succeeds but the mirror is now in a … Continue reading

Posted in Mirroring, Troubleshooting | Comments Off on Mirroring suspends with Assertion error

Corrupting a database page

To corrupt a database page for the purpose of testing DBCC and page restores etc, this is the process I use which I find easiest… 1. Download a copy of AdventureWorksLT2008 sample database… http://msftdbprodsamples.codeplex.com/releases/view/93587 2. Attach the database to your … Continue reading

Posted in Corruption | Comments Off on Corrupting a database page