INFRASTRUCTURE SOLUTIONS

Today we face problem in our CRM 2011
we tried to add new user as system administrator, but we received error (sql server error)
ofcourse it is general error and do not give any indication on the actual error.

then we checked the CRM server event veiwer and we found the following error

Error 605
Attempt to fetch logical page (1:4288) in database 8 failed. It belongs to allocation unit 72057594554679296 not to 72057594550353920.

and we take the following procedure to correct the issue:

first we checked the DB using the following queries:


DBCC CHECKDB ('MEDIU_MSCRM')

DBCC CHECKDB ('MSCRM_CONFIG')

each query is in separate page


We found error in the first DB, so we run the following Query to correct the indexing errors.

USE MEDIU_MSCRM
GO
EXEC sp_MSforeachtable@command1="print '?' DBCC DBREINDEX ('?', ' ', 80)"
GO
EXEC sp_updatestats
GO

The Problem then GONE :)

thanks to the following 2 posts:
 
http://www.sqlhub.com/2011/11/error-fix-msg-605-attempt-to-fetch.html
http://blog.sqlauthority.com/2007/01/31/sql-server-reindexing-database-tables-and-update-statistics-on-tables/