Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kariehonea
Starting Member
1 Post |
 Posted - 2008-01-02 : 21:15:53
|
| I have a problem with multiple databases on a server. I originally read another post that went into detail on this same error. After reading the post I decided to re-index the table to see if that would fix my issue. I started on Saturday by re-indexing a table on database 'a' - the process completed after that; I received another error on database 'b' on Monday i subsequently re-indexed all indexes on this database; today I have received the same message on database 'c' and 'd'. All post that I have read seem to point to an issue with only one database and not multiple databases. I have approximately 100 databases on this cluster - SQL 2000. The physical server logs only error shown is '000009ac.00001744::2007/12/29-15:12:58.848 ERR [CP] CppReadCheckpoint unable to copy file U:\Disk12Partition1\bd61e68e-a60f-4ca6-b9ae-df3b893e4bb2\00000001.CPT to C:\DOCUME~1\mscs\LOCALS~1\Temp\CLS302F.tmp, error 3000009ac.00001744::2007/12/29-15:12:58.848 ERR [CP] CppReadCheckpoint - Was that due to quorum resource not being up ???' before corruption of database 'a'. Here is the entire error if you think it will help. The error has been the same on all databases: 12/28/2007 6:23 AM A possible database consistency problem has been detected on database ‘ substituted_name'. DBCC CHECKDB and DBCC CHECKCATALOG should be run on database 'substituted_name'.. When I run the DBCC CHECKDB command I got these errors on Substite name database:DBCC results for 'FVD_A'.Msg 2511, Level 16, State 1, Line 1Table error: Object ID 165575628, Index ID 2. Keys out of order on page (1:12743984), slots 97 and 98.There are 72920059 rows in 2281375 pages for object 'FVD_A'.CHECKDB found 0 allocation errors and 1 consistency errors in table 'FVD_A' (object ID 165575628).DBCC results for 'FVD_CVS322'.Msg 2511, Level 16, State 1, Line 1Table error: Object ID 181575685, Index ID 2. Keys out of order on page (1:7250519), slots 30 and 31.I am at a loss. I believe we may have a bigger issue, but the SAN Administrator and Server Admin are saying there is nothing they can do. Do I have a true SQL Server issue or something else.HELP! |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-01-03 : 13:27:34
|
| The error about the checkpoint file means the cluster is generally unhappy, but I forget the way to fix that offhand. You need to run a cluster command to resync the cluster resources, I believe. That problem should be unrelated to the corruption of the databases. Are the databases on the same logical device as the quorum resources? If so, the cluster services could get edged out in requests to the disk. In a worst case scenario, I believe this would crash the whole cluster, but that does not seem to be your problem here. If the quorum and the databases are on separate disks, you may want to check to make sure that your virus scan software is ignoring the SQL Server data directories.Keep backups of these databases handy at all times, and make sure the backups are not being made to the same physical drives as the databases are on. If the physical drive goes, you do not want to have the backup(s) go with it. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-03 : 23:04:54
|
| Try rebuild index on FVD_A and FVD_CVS322. |
|
|
|
|
|
|
|
|
Table error: Object ID XX, Index ID X. Keys