Category Archives: Troubleshooting

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

Failed data collector upload job

When the MDW data collector fails the upload job, ┬áthe cached files start building up and the MDW database starts getting out of date. If you look at the SQL agent job history for the upload job you will likely … Continue reading

Posted in Troubleshooting | Comments Off on Failed data collector upload job

DBCC IND and DBCC PAGE

DBCC IND – use to lookup what pages are allocated to an object Syntax: DBCC IND ( database_name, table_name, index_id ) NOTE: there must be records in the table before this will return a result set. NULL values in the … Continue reading

Posted in Troubleshooting | Comments Off on DBCC IND and DBCC PAGE