We are getting the following message with one of our Great Plains databases. This started with trying to restore a bak file to a new sql server which was 2005 vs 2000. It would not restore. Eror message upon the restore attempt was related coverting from 2000 to 2005. Specifically: Database '' running the upgrade step from version 539 to 551. Msg 3167, Level 16, State 1, Line 1. Restore could not start database.
Thinking there was just an issue with the backup we went back to the server and looked into it some more. Found that no maintenance had ever been run. Tried to run a mtce plan, will not work. Then tried to run dbcc checkdb or dbcc checkcatalog. The results were:
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:2662) with latch type SH. sysobjects failed.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
then for catalog:
Server: Msg 2513, Level 16, State 2, Line 1
Table error: Object ID 40907763 (object '40907763') does not match between 'SYSCOLUMNS' and 'SYSOBJECTS'.......lots more of this then:
Location: p:\sql\ntdbms\storeng\drs\include\record.inl:1447
Expression: m_SizeRec > 0 && m_SizeRec <= MAXDATAROW
SPID: 57
Process ID: 1728
Connection Broken
Then tried dbcc checkdb with the repair fast, then repair rebuild then with the allow data loss options. None of them work. Same error messages.
So then we tried to move just the mdf using a single file attach script, then just attaching, then creating a new db and going through steps renaming the files to the test sever. None of these worked. Messges like the above restore attempt with the version.
Went back to the live server and queried some things. All the database tables seem intact as we can query and get the desired results. All issues seem to be with the sysobjects. We cannot DTS or right click on TABLES and view the datbases, so.. When we do DTS or try to look at the tables we get the error above at the end of the catalog results. We can log in to GP and click through error messages then we can work fine. The error messages GP throws all relate back to the same thing from researching them. What are our options to get this fixed? what have i not already tried? what am i missing?
Thanks.
Thinking there was just an issue with the backup we went back to the server and looked into it some more. Found that no maintenance had ever been run. Tried to run a mtce plan, will not work. Then tried to run dbcc checkdb or dbcc checkcatalog. The results were:
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:2662) with latch type SH. sysobjects failed.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
then for catalog:
Server: Msg 2513, Level 16, State 2, Line 1
Table error: Object ID 40907763 (object '40907763') does not match between 'SYSCOLUMNS' and 'SYSOBJECTS'.......lots more of this then:
Location: p:\sql\ntdbms\storeng\drs\include\record.inl:1447
Expression: m_SizeRec > 0 && m_SizeRec <= MAXDATAROW
SPID: 57
Process ID: 1728
Connection Broken
Then tried dbcc checkdb with the repair fast, then repair rebuild then with the allow data loss options. None of them work. Same error messages.
So then we tried to move just the mdf using a single file attach script, then just attaching, then creating a new db and going through steps renaming the files to the test sever. None of these worked. Messges like the above restore attempt with the version.
Went back to the live server and queried some things. All the database tables seem intact as we can query and get the desired results. All issues seem to be with the sysobjects. We cannot DTS or right click on TABLES and view the datbases, so.. When we do DTS or try to look at the tables we get the error above at the end of the catalog results. We can log in to GP and click through error messages then we can work fine. The error messages GP throws all relate back to the same thing from researching them. What are our options to get this fixed? what have i not already tried? what am i missing?
Thanks.