SQL Error while Testing the Database during the Upgrade Process

Business Central/NAV Developers Forum
1

SQL ErrorErrorHi All,

We up here are doing a navision Upgrade from 3.7 SP3 to 4.0 SP3 using the Navision Upgarde Toolkit.The first step in this involves testing of the databse of which we are supposed to upgrade,during this step i have encountered a SQL error.

Can you please tell me what is to be done to resolve this error.

"Error: The following SQL Server error(s) occurred: [Microsoft][ODBC SQL Server Driver][SQL Server]The In-row data USED page count for object “Index DeFrag Recommendations”, index ID 1, partition ID 301941660975104, alloc unit ID 301941660975104 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.
Error: The following SQL Server error(s) occurred: [Microsoft][ODBC SQL Server Driver][SQL Server]The In-row data RSVD page count for object "Index DeFrag Rec"

Thanks in advance…[:)]

2

It seems to be a corrupted database. Restore database again.

3

Hey thanks for the reply,

This is the latest Database that has been restored and there is only a minor chance of this database beeing corrupt.