June 4, 2008 at 10:42 am
When I try to restore the database, I get the following error message at the end of the restoring process:
"System.Data.SqlClient.SqlError: The statistics 'columns' is dependent on column 'columns'. (Microsoft.SqlServer.Smo)"
I have searched the web if anyone has come across the error but I don't seem to find anything.
June 5, 2008 at 8:16 am
Can you run a DBCC CHECHKDB WITH NO_INFOMSGS, ALL_ERRORMSGS on the database in question and post the results? Wondering if you might have corruption....
-- You can't be late until you show up.
June 6, 2008 at 10:13 am
Thank you, the problem is now solved.
I received the following message when I ran the command: DBCC CHECKDB WITH ALL_ERRORMSGS
The In-row data RSVD page count for object "table_name", index ID 0, partition ID 12345, alloc unit ID 12345 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.
I then ran the DBCC UPDATEUSAGE, and it seems it has resolved the problem.
Thank you again!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply