SQL Server 2000 Corrupt Database

Jun 16, 2006

my User database (DB) is on Drive E & System DB is on Drive C. going to replace Drive E due to HardDisk problem. i did DBCC CHECKDB on User DB & found no issue & errors.
as i am going to move Data file from Drive E to C & then Back from Drive C, once Drive is replace. my question is as error was about TORN PAGE ERROR & if i copy back from Drive C to Drive E which NEW & CLEAN Drive does this TORN PAGE ERROR will be back. Any help is appreciated.

<edit> Moved to Data Corruption Forum </edit>

View 7 Replies


ADVERTISEMENT

Corrupt SQL 2000 Database - Error 823

Jun 9, 2006

Robert writes "Is it possible to recover any data from a database that is throwing the following error in query analyzer?

select * from table1

server: msg 823, level 24, atate 2, line 1
I/O error (bad page ID) detected during read at offset 0x00000007b7e000 in file '... dbname.mdf'


I can select top n from some tables with no error, if n is too large, I get the same error. Other tables give this error even for top 1.

After setting the db in single_user mode, I tried dbcc checkdb with repair_allow_data_loss option and received the following:

msg 8966, level 16, state 1, line 1
could not read and latch page ( 1:15807 ) with latch type SH. sysindexes failed.

I tried dbcc checktable on sysindexes with repair_allow_data_loss option and received the following:

msg 8966, level 16, state 1, line 1
could not read and latch page ( 1:15807 ) with latch type SH. sysindexes failed.
msg 8966, level 16, state 1, line 1
table error: object id 0, indexid 0, page ID (1:15807) the pageid in the page header = (0:0)
The error has been repaired.

I get the same message each time I run the DBCC command.

I can select * from sysindexes with no problem.

If I select * from sysindexkeys, I get the following:

msg 601, level 12, state 3, line 1
could not continue scan with nolock due to data movement.

I'm wondering if sysindexkeys is corrupt and causing this problem?...

I have also tried to bcp data out of the database with no success.

Any help or advice would be greatly appreciated.

Thanks in advance.

Robert"

View 5 Replies View Related

Repairing Corrupt MSDB File In SQL Server 2000.

Jun 13, 2001

Hi,

I am having problems with my SQL server Agent.

1) When I try to create a New Job/Alert/Operator, I get an error message:

Error 207: Invalid Column Name "category_id"
Invalid Column Name "netsend_address"
Invalid Column Name "last_netsend_date"
Invalid Column Name "last_netsend_time"

.....All these are referring to columns in System Tables of the system Database MSDB.

2)In another SQL Server...say "A", in it's SQL Server Agent, using the Multi-Server Administration, I set up the SQL Server Agent of "A" as the Master (MSX) server, and set up a Target(TSX) server pointing to the Server "B" that has problems in SQL Agent....referred in 1) above. When I try to "Detach the MSX Server" from server B, i get a message Error 207: Invalid Column Name "netsend_address", and cannot detach..........This is again referrring to a System Table.

It appears that the problem is with the MSDB database being corrupt. Is there a way I can Repair a Corrupt MSDB without Re-installing SQL Server 2000 and without a Backup.

Any help greatly appreciate.

Thanks

Russell

View 6 Replies View Related

SQL 2005 Thinks A SQL 2000 Backup Is Corrupt, But SQL 2000 Restores Just Fine

Jul 19, 2007

I am attempting to move some SQL 2000 databases to SQL 2005. My main production database does not seem to want to move. When I use the SQL 2005 GUI the .bak backup file is marked 'Incomplete'. When I attempt to restore the backup file I get a 'RESTORE detected an error on page (0:0) in database' message. I saw a thread in the SQL Express forum suggesting trying to restore from the T-SQL level to get the GUI out of the picture and I get the same 'error on page (0:0)' message. However when I take the same file and use SQL 2000 Enterprise Manager it restores with no problems.

Any ideas?

Thanks
Mike Mattix

View 8 Replies View Related

SQL 2000 Is Corrupt

Nov 23, 2006

My installation of SQL 2000 is corrupt. THis occured after I uninsalled MS Business Contact Manager and then uninstalled SQL Server (Following ther advice of MS).

I then accidemtly installed an incorrect language version of the software (Dutch) instead of English. Uninstalled via the Add / Remover Programes tools and tried to reinstall the english version.

I have read artical 830477 which explains how to correct the situation however I donot know where to find the original setup files. (SQLrun01.msi) Are they hidden somewhere on the MSOffice 2003 CD or on the Business Contact Manager CD? If so where.

Also I am unable to remove the Business Contact Manager Software because the SQL installation is currupt.

Any advice as to how to solve this issue would be appreciated.







View 3 Replies View Related

SQL 2012 :: Database Recovery From Corrupt Database File?

Jul 9, 2014

Last week I backed up my SQL Server by using BE 2012. I named the file "SQL Server BAK" which contained copies of my SQL Server databases. A few days ago I lost some part of my data due to accidental deletion. I backed it up, so I tried to restore the database from the .bkf file. The problem comes here, when I try to to restore my .bkf file, it becomes inaccessible.what causes this?

View 7 Replies View Related

How To Fix A Corrupt Database

Mar 28, 2001

Hi All,

I am working in a test environment where I need to corrupt a database for test purpose/R&D. After corrupting the database, I ran the DBCC CHECKDB (pubs, repair_fast) and then DBCC CHECKDB (pubs, repair_rebuild) commands. But DBCC is not fixing the corrupt database.

My question is why DBCC is not fixing the corrupted Database? Is that a limitation of DBCC or is there any other way/command or tool to fix the corrupted database other then restoring from the previously backed up file.

The following are the steps that I followed to corrupt the database:
I used the following script (available in the script section of www.swynk.com) to corrupt the pubs database.

sp_configure allow, 1
go
reconfigure with override
go
update sysindexes set FirstIAM = 1234
where id = OBJECT_ID('roysched')
go
sp_configure allow, 0
go
reconfigure with override
go

Then I did a select * from roysched. I got the error:
Server: Msg 5180, Level 22, State 1, Line 1
Could not open FCB for invalid file ID 53764 in database 'pubs'. Table or database may be corrupted.

The pubs database got corrupted. Now, I want to fix this error. So I set the pubs database to single user mode and ran the DBCC command :
DBCC CHECKDB (pubs, repair_fast) that doesn't help so I ran the DBCC CHECKDB (pubs, repair_rebuild) command.

I got big DBCC output. I doesn't seems to fix the pubs database. When I did a select * from roysched again it gave the same corruption error.

I would appreciate any help in this issue.

Thanks
Sri

View 10 Replies View Related

Corrupt 6.5 Database

Dec 17, 2001

Very strange. I suspect McAfee Anti-Virus was run against SQL 6.5 files, but don't know for sure. Now server won't start. Rebuild master, it starts. Restore Master, it hangs. Rebuild master, Disk ReInit & ReFit devices, user database and server hangs while recovering db log on restart. A backup was made after the corruption got into db, so restoring db has same result, hang. Cannot open db to begin anything. Help?

View 1 Replies View Related

Corrupt Database

Jan 11, 2005

To make a very long story short, we had a SQL server that experienced problems as a result of bad sectors within one of the drives within a RAID5. Although the drive was replaced the server was never the same and we were forced to perform a migration.

After the migration we began noticing that the server had corrupt data. This was noticed after our applications began erroring out. We determined the corrupt table using DBCC CHECKTABLE and moved the data from those tables into a new table.

Our applications are now working without error, but now it seems as though our indexes are broken which would make sense becuase the tables have essentially been renamed. During an attempted DTS, I selected the option to NOT copy over indexes. I am getting the same error within a DTS as I am within the servers event logs.

Page (3:68379), slot 23 for text, ntext, or image node does not exist.
or
[SQL-DMO]Code execution exception: EXCEPTION_ACCESS_VIOLATION

This is one of the errors that helped determine that the database was corrupt in the beginning. To make it worse, our backups are useless becuase they will not restore. In order for me to use a backup, I have to copy the MDF and LDF from the production server and copy to the test environment server and then attach it. From the test server is where I was able to succesfully backup and restore.

I would have contacted MSFT a long time ago when this all got started. Unfortunately, I work for a company that will not spend the money on asking MSFT for help. I fear that the long this goes on, the worse it gets.

Please keep in mind that their is a lot of detail that is too must to detail here.

My question is, what would be the best way to essentially start over without losing the data? I assume that since a DTS is failing I am basically "SOL".

Does anyone have any suggestions?

Thank you all for your replies.

View 3 Replies View Related

Corrupt Database?

Jan 27, 2004

We have a table (> 4,000,000 rows) that appears to be missing data, but if we copy the table using "insert into new_table from bad_table" some of the missing data mysteriously reappears. I am assuming there is something wrong with the database, but I don't know where to begin. Can anyone give me some idea of what might be wrong? Thanks in advance!

View 2 Replies View Related

Corrupt Database

May 19, 2006

black_pearl writes "i want to know how to detect if a database in sql server 7 is corrupted. thanks."

View 2 Replies View Related

Database Corrupt

Feb 11, 2007

Dear all,

I have a very critical problem with corrupt database. Our main server got burned yesterday. There were very important data that went lost. We have a old computer that was used as the sql server 2000 before this machine was burned with the fire. We only want the initial data of the database so we swithched on the old computer but it was formated once. with recover my files we recovered the .mdf and .ldf files. mssqlrecover from officerecovery says recovery done with demo restriction. it recovers all item but the table value which we needed.

The databse is of 2.37 mb and when compressed 560 kb.
Can anybody please recover the data from the database?

View 2 Replies View Related

CORRUPT DATABASE

Feb 10, 2008

Hi,

I had an error on my server. It just froze and timed out on clients. After rebooting the server, SQL wouldnt run. I had to reinstall it. But this wasnt posible before i ad to reinstall the whole operating system. I had copied the data files to another disk. After sucesfully installing i attahced the data files. When i ran a query against the database, it gave me a connection broken error. After running DBCC CHECKDB it gave the following,

Server: Msg 8939, Level 16, State 5, Line 1
Table error: Object ID 0, index ID 0, page (1:50392). Test (m_headerVersion == HEADER_7_0) failed. Values are 0 and 1.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:50392). Test ((m_type >=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE && level == BASIC_HEADER)) failed. Values are 0 and 101.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:50392). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 0 and 8192.
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50393). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50394). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50395). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50396). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50397). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50398). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50399). The PageId in the page header = (0:0).
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:50400). Test (m_headerVersion == HEADER_7_0) failed. Values are 0 and 1.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:50400). Test ((m_type >=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE && level == BASIC_HEADER)) failed. Values are 0 and 101.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:50400). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 0 and 8192.
DBCC results for 'ALLIANCE'.
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50401). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50402). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50403). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50404). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50405). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50406). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50407). The PageId in the page header = (0:0).
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:50408). Test (m_headerVersion == HEADER_7_0) failed. Values are 0 and 1.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:50408). Test ((m_type >=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE && level == BASIC_HEADER)) failed. Values are 0 and 101.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:50408). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 0 and 8192.
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50409). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50410). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50411). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50412). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50413). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50414). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50415). The PageId in the page header = (0:0).
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:50416). Test (m_headerVersion == HEADER_7_0) failed. Values are 0 and 1.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:50416). Test ((m_type >=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE && level == BASIC_HEADER)) failed. Values are 0 and 101.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:50416). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 0 and 8192.
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50417). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50418). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50419). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50420). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50421). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50422). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50423). The PageId in the page header = (0:0).
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:50424). Test (m_headerVersion == HEADER_7_0) failed. Values are 0 and 1.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:50424). Test ((m_type >=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE && level == BASIC_HEADER)) failed. Values are 0 and 101.
Server: Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID 0, page (1:50424). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 0 and 8192.
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50425). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50426). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50427). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50428). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50429). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50430). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50431). The PageId in the page header = (0:0).
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:50432). Test (m_headerVersion == HEADER_7_0) failed. Values are 0 and 1.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:50432). Test ((m_type >=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE && level == BASIC_HEADER)) failed. Values are 0 and 101.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:50432). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 0 and 8192.
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50433). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50434). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50435). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50436). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50437). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50438). The PageId in the page header = (0:0).
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:50440). Test (m_headerVersion == HEADER_7_0) failed. Values are 0 and 1.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:50440). Test ((m_type >=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE && level == BASIC_HEADER)) failed. Values are 0 and 101.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:50440). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 0 and 8192.
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50441). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50442). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50443). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50444). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50445). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50446). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50447). The PageId in the page header = (0:0).
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:50448). Test (m_headerVersion == HEADER_7_0) failed. Values are 0 and 1.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:50448). Test ((m_type >=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE && level == BASIC_HEADER)) failed. Values are 0 and 101.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:50448). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 0 and 8192.
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50449). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50450). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50451). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50452). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50453). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50454). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50455). The PageId in the page header = (0:0).
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:50456). Test (m_headerVersion == HEADER_7_0) failed. Values are 0 and 1.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:50456). Test ((m_type >=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE && level == BASIC_HEADER)) failed. Values are 0 and 101.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:50456). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 0 and 8192.
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50457). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50458). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50459). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50460). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50461). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50462). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50463). The PageId in the page header = (0:0).
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:50464). Test (m_headerVersion == HEADER_7_0) failed. Values are 0 and 1.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:50464). Test ((m_type >=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE && level == BASIC_HEADER)) failed. Values are 0 and 101.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:50464). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 0 and 8192.
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50465). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50466). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50467). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50468). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50469). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50470). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50471). The PageId in the page header = (0:0).
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:50472). Test (m_headerVersion == HEADER_7_0) failed. Values are 0 and 1.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:50472). Test ((m_type >=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE && level == BASIC_HEADER)) failed. Values are 0 and 101.
Server: Msg 8939, Level 16, State 7, Line 1
Table error: Object ID 0, index ID 0, page (1:50472). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 0 and 8192.
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50473). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50474). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50475). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50476). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50477). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50478). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page ID (1:50479). The PageId in the page header = (0:0).
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:23), slot 3, text ID 28339339264 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:113), slot 6, text ID 28522708992 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:196), slot 7, text ID 28390916096 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:981), slot 3, text ID 28523692032 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:1459), slot 1, text ID 28340125696 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:1462), slot 1, text ID 28339208192 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:1730), slot 0, text ID 28334751744 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:1849), slot 0, text ID 28317712384 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2444), slot 0, text ID 28324593664 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2959), slot 18, text ID 28524019712 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:3250), slot 7, text ID 28340387840 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:3795), slot 5, text ID 28524281856 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:3797), slot 7, text ID 28390391808 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:4228), slot 1, text ID 28333703168 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:4807), slot 0, text ID 28427812864 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:4829), slot 3, text ID 28373745664 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:6110), slot 2, text ID 28325183488 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:6110), slot 16, text ID 28310962176 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:6504), slot 3, text ID 28311355392 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:7143), slot 6, text ID 28263186432 is not referenced.
CHECKDB found 0 allocation errors and 109 consistency errors not associated with any single object.
DBCC results for 'sysobjects'.
There are 2410 rows in 44 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:8028), slot 0, text ID 28325380096 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:12041), slot 1, text ID 28414771200 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:12998), slot 0, text ID 28373286912 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:13011), slot 3, text ID 28375777280 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:13012), slot 5, text ID 28380889088 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:13012), slot 8, text ID 28437577728 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:15449), slot 0, text ID 28342616064 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:15451), slot 3, text ID 28312731648 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:18821), slot 0, text ID 28409790464 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:19300), slot 3, text ID 28391047168 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:21496), slot 3, text ID 28436004864 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:21503), slot 0, text ID 28293201920 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:27748), slot 4, text ID 28392292352 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:30921), slot 10, text ID 28389998592 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:31816), slot 8, text ID 28541321216 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:43500), slot 0, text ID 28524412928 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:43503), slot 0, text ID 28524544000 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:43566), slot 3, text ID 28407037952 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:43601), slot 2, text ID 28391702528 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:43753), slot 0, text ID 28409528320 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:44345), slot 0, text ID 28413198336 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:44350), slot 6, text ID 28342943744 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:44367), slot 0, text ID 28413919232 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:44817), slot 2, text ID 28541386752 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:44831), slot 3, text ID 28316991488 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:45234), slot 8, text ID 28374204416 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:45271), slot 3, text ID 28344123392 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:45672), slot 0, text ID 28409659392 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:45676), slot 0, text ID 28409856000 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:46112), slot 6, text ID 28424601600 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:46735), slot 11, text ID 28379250688 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:47001), slot 13, text ID 28522577920 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:47707), slot 11, text ID 28424273920 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:49035), slot 2, text ID 28292349952 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:49037), slot 10, text ID 28427681792 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:49104), slot 1, text ID 28427747328 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:49106), slot 10, text ID 28522512384 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:49109), slot 11, text ID 28424863744 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:49110), slot 3, text ID 28389605376 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:49362), slot 8, text ID 28263907328 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:49366), slot 4, text ID 28263579648 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:50120), slot 2, text ID 28310896640 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:50121), slot 12, text ID 28312207360 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:50121), slot 13, text ID 28312403968 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:50122), slot 3, text ID 28311617536 is not referenced.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 2, index ID 255: Page (1:50424) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 2, index ID 255: Page (1:50425) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 2, index ID 255: Page (1:50426) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 2, index ID 255: Page (1:50427) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 2, index ID 255: Page (1:50428) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 2, index ID 255: Page (1:50429) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 2, index ID 255: Page (1:50430) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 2, index ID 255: Page (1:50431) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 2, index ID 255: Page (1:50432) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 2, index ID 255: Page (1:50433) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 2, index ID 255: Page (1:50434) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 2, index ID 255: Page (1:50435) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 2, index ID 255: Page (1:50436) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 2, index ID 255: Page (1:50437) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 2, index ID 255: Page (1:50438) could not be processed. See other errors for details.
There are 4841 rows in 241 pages for object 'sysindexes'.
CHECKDB found 0 allocation errors and 80 consistency errors in table 'sysindexes' (object ID 2).
DBCC results for 'syscolumns'.
There are 13391 rows in 293 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 1960 rows in 185 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 51 rows in 1 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 12 rows in 1 pages for object 'sysusers'.
DBCC results for 'sysproperties'.
There are 875 rows in 27 pages for object 'sysproperties'.
DBCC results for 'sysdepends'.
There are 5062 rows in 27 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 0 rows in 1 pages for object 'sysreferences'.
DBCC results for 'sysfulltextcatalogs'.
There are 0 rows in 1 pages for object 'sysfulltextcatalogs'.
DBCC results for 'sysfulltextnotify'.
There are 0 rows in 0 pages for object 'sysfulltextnotify'.
DBCC results for 'sysfilegroups'.
There are 1 rows in 1 pages for object 'sysfilegroups'.
DBCC results for 'ClassTreatiesFY'.
There are 167 rows in 2 pages for object 'ClassTreatiesFY'.
DBCC results for 'Risks'.
There are 68548 rows in 1424 pages for object 'Risks'.
DBCC results for 'LkpRenYear'.
There are 4 rows in 1 pages for object 'LkpRenYear'.
DBCC results for 'MOCBuildings'.
There are 23 rows in 1 pages for object 'MOCBuildings'.
DBCC results for 'MOCBusinessAllRisk'.
There are 129 rows in 4 pages for object 'MOCBusinessAllRisk'.
DBCC results for 'AARTransit'.
There are 1656 rows in 234 pages for object 'AARTransit'.
DBCC results for 'MOCDamageDetail'.
There are 0 rows in 1 pages for object 'MOCDamageDetail'.
DBCC results for 'AARGlass'.
There are 1647 rows in 236 pages for object 'AARGlass'.
DBCC results for 'dtproperties'.
There are 0 rows in 0 pages for object 'dtproperties'.
DBCC results for 'RIMotor'.
There are 1030 rows in 97 pages for object 'RIMotor'.
DBCC results for 'MOCEEquipment'.
There are 38 rows in 2 pages for object 'MOCEEquipment'.
DBCC results for 'CMPMachBDLOP'.
There are 303 rows in 17 pages for object 'CMPMachBDLOP'.
DBCC results for 'AARMatDamage'.
There are 4 rows in 1 pages for object 'AARMatDamage'.
DBCC results for 'DHCPrivateMotor'.
There are 0 rows in 1 pages for object 'DHCPrivateMotor'.
DBCC results for 'AARAccDamage'.
There are 1847 rows in 270 pages for object 'AARAccDamage'.
DBCC results for 'LkpactionStatus'.
There are 2 rows in 1 pages for object 'LkpactionStatus'.
DBCC results for 'RIOffice'.
There are 13 rows in 1 pages for object 'RIOffice'.
DBCC results for 'MOCEmployerLiability'.
There are 14 rows in 1 pages for object 'MOCEmployerLiability'.
DBCC results for 'Range'.
There are 12 rows in 2 pages for object 'Range'.
DBCC results for 'BondsGuarantee'.
There are 277 rows in 9 pages for object 'BondsGuarantee'.
DBCC results for 'MOCFidelity'.
There are 0 rows in 1 pages for object 'MOCFidelity'.
DBCC results for 'CMPMoney'.
There are 918 rows in 97 pages for object 'CMPMoney'.
DBCC results for 'Broker'.
There are 104 rows in 3 pages for object 'Broker'.
DBCC results for 'LkpLiveStockCover'.
There are 0 rows in 1 pages for object 'LkpLiveStockCover'.
DBCC results for 'FMPFire'.
There are 2353 rows in 96 pages for object 'FMPFire'.
DBCC results for 'CMPAccountsReceviables'.
There are 96 rows in 3 pages for object 'CMPAccountsReceviables'.
DBCC results for 'SIRangesOld'.
There are 2158 rows in 34 pages for object 'SIRangesOld'.
DBCC results for 'MOCFidelityGuarantee'.
There are 6 rows in 2 pages for object 'MOCFidelityGuarantee'.
DBCC results for 'PriProfIndemnity'.
There are 78 rows in 3 pages for object 'PriProfIndemnity'.
DBCC results for 'FMPTheft'.
There are 347 rows in 17 pages for object 'FMPTheft'.
DBCC results for 'AARMatDamageOther'.
There are 5 rows in 2 pages for object 'AARMatDamageOther'.
DBCC results for 'Classes'.
There are 89993 rows in 1438 pages for object 'Classes'.
DBCC results for 'AARClmPrepCosts'.
There are 3 rows in 1 pages for object 'AARClmPrepCosts'.
DBCC results for 'LkpVehType'.
There are 8 rows in 2 pages for object 'LkpVehType'.
DBCC results for 'FMPMoney'.
There are 511 rows in 28 pages for object 'FMPMoney'.
DBCC results for 'RIAAR'.
There are 214 rows in 28 pages for object 'RIAAR'.
DBCC results for 'MOCFire'.
There are 1 rows in 1 pages for object 'MOCFire'.
DBCC results for 'TreatiesFY'.
There are 23 rows in 1 pages for object 'TreatiesFY'.
DBCC results for 'CMPEEquipment'.
There are 5627 rows in 397 pages for object 'CMPEEquipment'.
DBCC results for 'FMPBusinessAllRisk'.
There are 2414 rows in 153 pages for object 'FMPBusinessAllRisk'.
DBCC results for 'LkpVehCapacity'.
There are 4 rows in 1 pages for object 'LkpVehCapacity'.
DBCC results for 'FMPGoodsInTransit'.
There are 231 rows in 20 pages for object 'FMPGoodsInTransit'.
DBCC results for 'MOCGlass'.
There are 11 rows in 1 pages for object 'MOCGlass'.
DBCC results for 'TreatyRetentionsFY'.
There are 106 rows in 1 pages for object 'TreatyRetentionsFY'.
DBCC results for 'FMPPublicLiability'.
There are 813 rows in 60 pages for object 'FMPPublicLiability'.
DBCC results for 'MTRMotorPrivate'.
There are 76821 rows in 9045 pages for object 'MTRMotorPrivate'.
DBCC results for 'LkpNextClaim'.
There are 30 rows in 2 pages for object 'LkpNextClaim'.
DBCC results for 'RIDomestic'.
There are 143 rows in 6 pages for object 'RIDomestic'.
DBCC results for 'IndTemp'.
There are 1 rows in 1 pages for object 'IndTemp'.
DBCC results for 'PolicyTreaties'.
There are 62030 rows in 1130 pages for object 'PolicyTreaties'.
DBCC results for 'FMPHouseOwner'.
There are 1847 rows in 60 pages for object 'FMPHouseOwner'.
DBCC results for 'RIMoney'.
There are 56 rows in 4 pages for object 'RIMoney'.
DBCC results for 'MOCGoodsInTransit'.
There are 8 rows in 1 pages for object 'MOCGoodsInTransit'.
DBCC results for 'Creditors'.
There are 336 rows in 10 pages for object 'Creditors'.
DBCC results for 'RIGlass'.
There are 58 rows in 2 pages for object 'RIGlass'.
DBCC results for 'RIGoodsInTransit'.
There are 34 rows in 3 pages for object 'RIGoodsInTransit'.
DBCC results for 'MOCGroupPA'.
There are 34 rows in 2 pages for object 'MOCGroupPA'.
DBCC results for 'Teams'.
There are 4 rows in 1 pages for object 'Teams'.
DBCC results for 'AllianceBranches'.
There are 3 rows in 1 pages for object 'AllianceBranches'.
DBCC results for 'TreatyRetentions'.
There are 88 rows in 2 pages for object 'TreatyRetentions'.
DBCC results for 'LkpUserClass'.
There are 0 rows in 1 pages for object 'LkpUserClass'.
DBCC results for 'RIBusinessAllRisk'.
There are 77 rows in 3 pages for object 'RIBusinessAllRisk'.
DBCC results for 'UPR'.
There are 12 rows in 1 pages for object 'UPR'.
DBCC results for 'RiGrpLink'.
There are 0 rows in 1 pages for object 'RiGrpLink'.
DBCC results for 'RIPublicLiability'.
There are 39 rows in 3 pages for object 'RIPublicLiability'.
DBCC results for 'MOCMachBDLOP'.
There are 3 rows in 1 pages for object 'MOCMachBDLOP'.
DBCC results for 'LkpNextNumMutare'.
There are 27 rows in 1 pages for object 'LkpNextNumMutare'.
DBCC results for 'RIEmployerLiability'.
There are 7 rows in 1 pages for object 'RIEmployerLiability'.
DBCC results for 'RIGroupPA'.
There are 32 rows in 3 pages for object 'RIGroupPA'.
DBCC results for 'MOCMachBreakDown'.
There are 0 rows in 1 pages for object 'MOCMachBreakDown'.
DBCC results for 'LkpNextNumByo'.
There are 27 rows in 1 pages for object 'LkpNextNumByo'.
DBCC results for 'LkpTeaties'.
There are 4 rows in 1 pages for object 'LkpTeaties'.
DBCC results for 'MOCMoney'.
There are 18 rows in 1 pages for object 'MOCMoney'.
DBCC results for 'DHCAllRisks'.
There are 14536 rows in 402 pages for object 'DHCAllRisks'.
DBCC results for 'MRNHull'.
There are 2102 rows in 201 pages for object 'MRNHull'.
DBCC results for 'LkpTYear'.
There are 1 rows in 1 pages for object 'LkpTYear'.
DBCC results for 'LkpAttention'.
There are 236 rows in 2 pages for object 'LkpAttention'.
DBCC results for 'MOCOfficeContents'.
There are 0 rows in 1 pages for object 'MOCOfficeContents'.
DBCC results for 'CMPFidelity'.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50392) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50393) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50394) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50395) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50396) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50397) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50398) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50399) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50400) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50401) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50402) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50403) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50404) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50405) could not be processed. See other errors for details.
There are 0 rows in 1 pages for object 'CMPFidelity'.
DBCC results for 'FMPMotor'.
There are 11922 rows in 1112 pages for object 'FMPMotor'.
DBCC results for 'Policies'.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50406) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50407) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50408) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50409) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50410) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50411) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50412) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50413) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50414) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50415) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50416) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50417) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50418) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50419) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50420) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50421) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50422) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50423) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50440) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50441) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50442) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50443) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50444) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50445) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50446) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50447) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50448) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50449) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50450) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50451) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50452) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50453) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50454) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50455) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50456) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50457) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50458) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50459) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50460) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50461) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50462) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50463) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50464) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50465) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50466) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50467) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50468) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50469) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50470) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50471) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50472) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50473) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50474) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50475) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50476) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50477) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50478) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 514257037, index ID 0: Page (1:50479) could not be processed. See other errors for details.
There are 20115 rows in 1236 pages for object 'Policies'.
CHECKDB found 0 allocation errors and 72 consistency errors in table 'Policies' (object ID 514257037).
DBCC results for 'CMPBuildings'.
There are 742 rows in 60 pages for object 'CMPBuildings'.
DBCC results for 'MOCPublicLiability'.
There are 50 rows in 3 pages for object 'MOCPublicLiability'.
DBCC results for 'CMPFidelityGuarantee'.
There are 391 rows in 21 pages for object 'CMPFidelityGuarantee'.
DBCC results for 'FMPCaravans'.
There are 0 rows in 1 pages for object 'FMPCaravans'.
DBCC results for 'LkpClasses'.
There are 0 rows in 1 pages for object 'LkpClasses'.
DBCC results for 'Underwriters'.
There are 16 rows in 2 pages for object 'Underwriters'.
DBCC results for 'MOCStatBenefits'.
There are 0 rows in 1 pages for object 'MOCStatBenefits'.
DBCC results for 'RITheft'.
There are 77 rows in 3 pages for object 'RITheft'.
DBCC results for 'LkpLocation'.
There are 33 rows in 2 pages for object 'LkpLocation'.
DBCC results for 'MOCTheft'.
There are 14 rows in 2 pages for object 'MOCTheft'.
DBCC results for 'UPRQtr'.
There are 3 rows in 1 pages for object 'UPRQtr'.
DBCC results for 'RIFidelityGuarantee'.
There are 1 rows in 1 pages for object 'RIFidelityGuarantee'.
DBCC results for 'LKpCover'.
There are 7 rows in 2 pages for object 'LKpCover'.
DBCC results for 'EngPlantAllRisk'.
There are 228 rows in 14 pages for object 'EngPlantAllRisk'.
DBCC results for 'MOCFireOffice'.
There are 25 rows in 1 pages for object 'MOCFireOffice'.
DBCC results for 'LkpWall'.
There are 3 rows in 1 pages for object 'LkpWall'.
DBCC results for 'AARPersonalEffects'.
There are 1472 rows in 219 pages for object 'AARPersonalEffects'.
DBCC results for 'UPRBiAnn'.
There are 6 rows in 1 pages for object 'UPRBiAnn'.
DBCC results for 'LkpNextNum'.
There are 28 rows in 2 pages for object 'LkpNextNum'.
DBCC results for 'MOCBnsInterruption'.
There are 1 rows in 1 pages for object 'MOCBnsInterruption'.
DBCC results for 'LkpHouseType'.
There are 4 rows in 1 pages for object 'LkpHouseType'.
DBCC results for 'AARAnyLoss'.
There are 1647 rows in 235 pages for object 'AARAnyLoss'.
DBCC results for 'Schedules'.
There are 165 rows in 4 pages for object 'Schedules'.
DBCC results for 'lkpPayee'.
There are 8 rows in 1 pages for object 'lkpPayee'.
DBCC results for 'LkpRiskAdress'.
There are 0 rows in 1 pages for object 'LkpRiskAdress'.
DBCC results for 'AARMoney'.
There are 1871 rows in 336 pages for object 'AARMoney'.
DBCC results for 'FMPFarmersLiability'.
There are 0 rows in 1 pages for object 'FMPFarmersLiability'.
DBCC results for 'LkpPayeeType'.
There are 4 rows in 1 pages for object 'LkpPayeeType'.
DBCC results for 'LkpPaymentReason'.
There are 3 rows in 1 pages for object 'LkpPaymentReason'.
DBCC results for 'LkpClientStatus'.
There are 5 rows in 1 pages for object 'LkpClientStatus'.
DBCC results for 'CMPGroupPA'.
There are 1982 rows in 286 pages for object 'CMPGroupPA'.
DBCC results for 'AARTheft'.
There are 1918 rows in 281 pages for object 'AARTheft'.
DBCC results for 'CommRate'.
There are 2049 rows in 8 pages for object 'CommRate'.
DBCC results for 'Receipts'.
There are 2099 rows in 74 pages for object 'Receipts'.
DBCC results for 'CMPMachBreakDown'.
There are 0 rows in 1 pages for object 'CMPMachBreakDown'.
DBCC results for 'CMPTheft'.
There are 1040 rows in 43 pages for object 'CMPTheft'.
DBCC results for 'GolfAllRisks'.
There are 321 rows in 8 pages for object 'GolfAllRisks'.
DBCC results for 'CMPOfficeContents'.
There are 0 rows in 1 pages for object 'CMPOfficeContents'.
DBCC results for 'LkpRoof'.
There are 3 rows in 1 pages for object 'LkpRoof'.
DBCC results for 'CommRateInsurer'.
There are 1014 rows in 4 pages for object 'CommRateInsurer'.
DBCC results for 'LkpMonthes'.
There are 12 rows in 1 pages for object 'LkpMonthes'.
DBCC results for 'CMPPublicLiability'.
There are 2888 rows in 362 pages for object 'CMPPublicLiability'.
DBCC results for 'GolfPubLiab'.
There are 71 rows in 5 pages for object 'GolfPubLiab'.
DBCC results for 'LkpNextPaymentNum'.
There are 1 rows in 1 pages for object 'LkpNextPaymentNum'.
DBCC results for 'lkpPayment'.
There are 3 rows in 1 pages for object 'lkpPayment'.
DBCC results for 'CMPSuppliers'.
There are 7 rows in 2 pages for object 'CMPSuppliers'.
DBCC results for 'GolfGroupPA'.
There are 42 rows in 4 pages for object 'GolfGroupPA'.
DBCC results for 'MTRMotorFleet'.
There are 3272 rows in 603 pages for object 'MTRMotorFleet'.
DBCC results for 'AARProfits'.
There are 979 rows in 87 pages for object 'AARProfits'.
DBCC results for 'FMPLivestock'.
There are 148 rows in 8 pages for object 'FMPLivestock'.
DBCC results for 'GolfPEffects'.
There are 299 rows in 8 pages for object 'GolfPEffects'.
DBCC results for 'ExpPol'.
There are 503 rows in 2 pages for object 'ExpPol'.
DBCC results for 'LKpCommodities'.
There are 21 rows in 2 pages for object 'LKpCommodities'.
DBCC results for 'RIFleet'.
There are 219 rows in 17 pages for object 'RIFleet'.
DBCC results for 'LkpPayStatus'.
There are 5 rows in 2 pages for object 'LkpPayStatus'.
DBCC results for 'SafPubLiab'.
There are 731 rows in 65 pages for object 'SafPubLiab'.
DBCC results for 'Golfhole'.
There are 83 rows in 5 pages for object 'Golfhole'.
DBCC results for 'LkpRelation'.
There are 4 rows in 1 pages for object 'LkpRelation'.
DBCC results for 'RIBondsGuarantee'.
There are 61 rows in 3 pages for object 'RIBondsGuarantee'.
DBCC results for 'CMPDamageDetail'.
There are 0 rows in 1 pages for object 'CMPDamageDetail'.
DBCC results for 'FMPHull'.
There are 40 rows in 2 pages for object 'FMPHull'.
DBCC results for 'LkpPayCode'.
There are 10 rows in 2 pages for object 'LkpPayCode'.
DBCC results for 'LkpItemName'.
There are 7 rows in 2 pages for object 'LkpItemName'.
DBCC results for 'CMPOfFire'.
There are 42 rows in 3 pages for object 'CMPOfFire'.
DBCC results for 'FMPImplementso'.
There are 0 rows in 1 pages for object 'FMPImplementso'.
DBCC results for 'LkpCountries'.
There are 10 rows in 2 pages for object 'LkpCountries'.
DBCC results for 'RISafPubLiab'.
There are 38 rows in 3 pages for object 'RISafPubLiab'.
DBCC results for 'OFCBuildings'.
There are 3 rows in 1 pages for object 'OFCBuildings'.
DBCC results for 'lkpRiskCode'.
There are 9 rows in 1 pages for object 'lkpRiskCode'.
DBCC results for 'LkpCommRates'.
There are 0 rows in 1 pages for object 'LkpCommRates'.
DBCC results for 'OFCFire'.
There are 444 rows in 25 pages for object 'OFCFire'.
DBCC results for 'MTRTradersInternalRisk'.
There are 268 rows in 17 pages for object 'MTRTradersInternalRisk'.
DBCC results for 'LkpClaimCause'.
There are 24 rows in 2 pages for object 'LkpClaimCause'.
DBCC results for 'AmtTemp'.
There are 0 rows in 1 pages for object 'AmtTemp'.
DBCC results for 'OFCMoney'.
There are 180 rows in 13 pages for object 'OFCMoney'.
DBCC results for 'MTRTER'.
There are 0 rows in 1 pages for object 'MTRTER'.
DBCC results for 'MRNCargo'.
There are 61 rows in 5 pages for object 'MRNCargo'.
DBCC results for 'LkpClaimType'.
There are 21 rows in 2 pages for object 'LkpClaimType'.
DBCC results for 'LkpAction'.
There are 2 rows in 1 pages for object 'LkpAction'.
DBCC results for 'FMPCrops'.
There are 413 rows in 19 pages for object 'FMPCrops'.
DBCC results for 'PolicyEnqTemp'.
There are 2 rows in 1 pages for object 'PolicyEnqTemp'.
DBCC results for 'LkpClaimStatus'.
There are 4 rows in 1 pages for object 'LkpClaimStatus'.
DBCC results for 'FMPTobacco'.
There are 778 rows in 32 pages for object 'FMPTobacco'.
DBCC results for 'FMPPublicLiabilityo'.
There are 0 rows in 1 pages for object 'FMPPublicLiabilityo'.
DBCC results for 'ClaimsPd'.
There are 42 rows in 2 pages for object 'ClaimsPd'.
DBCC results for 'Unallocated'.
There are 70 rows in 2 pages for object 'Unallocated'.
DBCC results for 'CMPFire'.
There are 2335 rows in 202 pages for object 'CMPFire'.
DBCC results for 'LkpCarbonTax'.
There are 0 rows in 1 pages for object 'LkpCarbonTax'.
DBCC results for 'LkpSchemes'.
There are 16 rows in 2 pages for object 'LkpSchemes'.
DBCC results for 'FMPGoodsInTransito'.
There are 0 rows in 1 pages for object 'FMPGoodsInTransito'.
DBCC results for 'DebtorsAging'.
There are 5610 rows in 72 pages for object 'DebtorsAging'.
DBCC results for 'FMPHouseHolder'.
There are 1361 rows in 53 pages for object 'FMPHouseHolder'.
DBCC results for 'LkpCanceReason'.
There are 3 rows in 1 pages for object 'LkpCanceReason'.
DBCC results for 'lkpWording'.
There are 23 rows in 2 pages for object 'lkpWording'.
DBCC results for 'CMPStatBenefits'.
There are 0 rows in 1 pages for object 'CMPStatBenefits'.
DBCC results for 'CMPEmployerLiability'.
There are 803 rows in 29 pages for object 'CMPEmployerLiability'.
DBCC results for 'LlkpMode'.
There are 4 rows in 1 pages for object 'LlkpMode'.
DBCC results for 'RiskAdress'.
There are 13700 rows in 238 pages for object 'RiskAdress'.
DBCC results for 'Transactions'.
There are 0 rows in 1 pages for object 'Transactions'.
DBCC results for 'FMPGroupPA'.
There are 583 rows in 34 pages for object 'FMPGroupPA'.
DBCC results for 'Allocatedtemp'.
There are 56 rows in 1 pages for object 'Allocatedtemp'.
DBCC results for 'Claims'.
There are 175 rows in 13 pages for object 'Claims'.
DBCC results for 'MTRTIR'.
There are 0 rows in 1 pages for object 'MTRTIR'.
DBCC results for 'CAR'.
There are 63 rows in 7 pages for object 'CAR'.
DBCC results for 'LkpCGF'.
There are 8 rows in 1 pages for object 'LkpCGF'.
DBCC results for 'MRNOpen'.
There are 371 rows in 45 pages for object 'MRNOpen'.
DBCC results for 'LkpTransCode'.
There are 4 rows in 2 pages for object 'LkpTransCode'.
DBCC results for 'LkpNextNumEndorse'.
There are 1 rows in 1 pages for object 'LkpNextNumEndorse'.
DBCC results for 'Insurers'.
There are 45 rows in 2 pages for object 'Insurers'.
DBCC results for 'LkpVehUse'.
There are 26 rows in 2 pages for object 'LkpVehUse'.
DBCC results for 'OFCPublicLiab'.
There are 4 rows in 1 pages for object 'OFCPublicLiab'.
DBCC results for 'LkpScope'.
There are 0 rows in 1 pages for object 'LkpScope'.
DBCC results for 'ErectionAR'.
There are 17 rows in 2 pages for object 'ErectionAR'.
DBCC results for 'LkpNextNumRenew'.
There are 1 rows in 1 pages for object 'LkpNextNumRenew'.
DBCC results for 'OFCPublicLiabPrd'.
There are 4 rows in 1 pages for object 'OFCPublicLiabPrd'.
DBCC results for 'Insured'.
There are 12462 rows in 170 pages for object 'Insured'.
DBCC results for 'SumAging'.
There are 0 rows in 1 pages for object 'SumAging'.
DBCC results for 'OFCTenants'.
There are 248 rows in 17 pages for object 'OFCTenants'.
DBCC results for 'LkpTitle'.
There are 7 rows in 1 pages for object 'LkpTitle'.
DBCC results for 'MTRTradersExternalRisk'.
There are 294 rows in 19 pages for object 'MTRTradersExternalRisk'.
DBCC results for 'Products'.
There are 109 rows in 4 pages for object 'Products'.
DBCC results for 'LkpNextNumCancel'.
There are 1 rows in

View 1 Replies View Related

How To Fix Corrupt Database?

Oct 4, 2006

Hello,

I am trying to run the example program: Coding4Fun: Building a Family History Web Service at this URL

http://msdn.microsoft.com/coding4fun/xmlforfun/familyhistory/default.aspx

The project has an SQL Express database Family.mdf. When I try and open Family.mdf in VS 2005, I get this error:

'FAMILY.MDF' cannot be upgraded because its non-release version (587) is not supported by this version of SQL Server. You cannot open a database that is incompatible with this version of sqlservr.exe. You must re-create the database.

I can create a new database, but then the stored procedures will be lost.

Any suggestions how to repair the database?

Thanks

View 3 Replies View Related

How To Find That The Database Is Corrupt

Jan 6, 2002

Hi,

I am new to sqlserver. we are using sqlserver 6.5.
these is no dbcc checkdb,checkalloc has been ran on the database for more than a uear, and dbcc updateusage has been run daily. Still now no errors are seen on the errorlog. The database has been restored daily on a different server too.

How can we confirm that the database is good. Will the database show suspect if there is a single table gets corrupt.or the dbcc update usage will say that the table is corrupted.

Suppose if I run the checkdb and checkalloc on the server now (after a year), will there be a possibility of table corrupt seen and how can I handle the database in this situation.

It is very much appreciated if any of you clear my doubt.

Thanks,
newbee

View 2 Replies View Related

Corrupt Table In SMS Database

Feb 25, 2000

Folks,
I am running SQL 7.0 & SMS 2.0. I get the following message while running DBCC CHECKCATALOG on my SMS database.

"Table Corrupt: Object ID 322100188 (object 'Summarizer_ComponentTallys') does not match between 'SYSREFERENCES' and 'SYSCOLUMNS.'."


This prevents my nightly tape backup as well.. Veritas (Backupexec) nightly as well. Is there a fix for this? This has been happening since we installed SMS 2.0 sometime in December.

Thanks.
Sam

View 1 Replies View Related

Urgent - Corrupt Database

Oct 28, 1999

I am facing a very weird problem. SQL Server database had gone corrupt and i restored the mdf and ldf files. After this i am able to see the table names thru sp_help command and also in SQL Enterprise mgr. But when i do a SELECT from the table it says the object doesn't exist. And if i link the sql table in MS-Access and then view it in access, it shows me the records !. Can someone pls tell me what could be the problem in SQL server and how to solve that.

Thanks.

View 1 Replies View Related

Error 601 - Corrupt Database??

Sep 10, 1999

I am getting an error every so often on my databases,
I get the following error,
DEscriptor for system table 8 in database not found in hash table,
the databses are unusalble until I stop SQL & shut down

I checked the books on line and it says to stop SQL and shut down,
I have done this and it solves the problem temporaily,

Is there any way that I can permanently fix this,

If anyobne has any ideas I'd appreciate it,
Thanks,
Fin

View 1 Replies View Related

Recreating A Corrupt Database!

Nov 3, 1998

Hello all,

I'm in a bit of a bind. We have a database that spits out a classic corruption error message whenever attempting to run scheduled maintenance:

Error:605, Severity: 21, State: 1
Attempt to fetch logical page ### in databbase 'db1' belongs to object 'table1' not object 'table2'

SQL Books Online says to check with DBCC checkDB and CheckAlloc asap, which I did, and CheckAlloc confirmed the corruption. Books Online's only advice at this point is to restore the DB from a clean backup.

Herein lies the problem. One I'm assuming has happened to many a DBA as well.

This particular message has been going on for months, and there is no "clean" backup of the database, because no-one here at the time knew there were any problems to take precautions. Now I'm here with a corrupt database, and no idea how one goes about reconstructing a DB from scratch. Does anybody out there know any good options?

Thanks in Advance

Fenderson

View 4 Replies View Related

Database Crashed Mdf Is Corrupt And Problems With The Ldf

Jan 24, 2007

Bill writes "Our SQL server crashed hard and now we can not get the mdf to attached without a bunch of errors in most of the tables. Any suggestions on a third party tool to fix the problem would be helpful. I had an engineer from Microsoft try to recover the database with no luck. So far I have found these third party tools Red Gate SQL Log Rescue, Lumigent Log Explorer for SQL Server, ApexSQL, and MSSQLRecovery. Oh yes, the backups or lack of backups are bad too. Anyone have any ideas?"

View 1 Replies View Related

Database Corrupt , I Want Delete Some Table

Nov 1, 2006

I have database currupt some table , I want to delete / drop table

Example

1. databaseTest Have --> table customer , table payment , table sales

2. table Payment can't select / drop / insert /rename (fail) show message error below

ERROR (Row 0);
Microsoft SQL Server 2000 Windows CE Edition:
"The database file is corrupted. (Database name: "" )"

3.How to drop table Payment (I want to drop and create table again and insert data to new table ) Or How to solution for repare table Payment

Thank You

Suwimol

View 3 Replies View Related

Database Corrupt On Power Loss

Mar 20, 2007

We are planning to use SQL Compact for an industrial control application.

We selected this database based on the assuption that it will survive when power is lost in the middle of a transaction.

We setup a test where we open a connection, write to database and randomly shut of the power while writing to database.

We are running on XPE with EWF enabled for C drive. Database is on D drive.

We cycle the power every ~ 20 seconds.

When the power comes back on, we Verify the database and if return is FALSE we Repair.

The database gets corrupted after 15 to 24 hours.

Looking at the log, for the first 12 hours there is no Repair going on. Every time the Verify returns True. After that, we start seeing Repair going on. The messages in the log are one or more of the following:

"Page with valid ordinal not found - idPage: 1, iPage: 3151"

"Block page not found - pwszTable: EventLogTable, idPage: 4678"

"Selected page not found - idPage: 4951, iPage: 3935"

After a couple more hours of repairing , the database corrupts completely and our application does not start anymore. The database file is always 20K when it gets corrupted.

Is there any setup to be done for the OS or the SQL to be able to survive this kind of test?

Is there anything to do to the database to prevent the corruption?



View 15 Replies View Related

Get Corrupt Database With Dbcc Checkdb Or Newalloc

Jul 8, 1999

Hi

Our supplyer of application we use say that dbcc checkdb or dbcc newalloc can
give corrupt database (use version 6.5). I wonders about this statement. Are ther some how have explanation about this

Kent vahlen

View 2 Replies View Related

SQL 2012 :: Model Database Files Missing - Inaccessible Or Corrupt

Aug 12, 2015

Been practicing DR strategies with a test SQL instance by following the scenarios listed here: [URL] ....

> Took a backup of the Model database
> Stopped SQL Server
> Deleted model database data & log file
> Started SQL Server and it obviously wouldn't start because TempDB needs a model database present.
> Started SQL instance with trace flags 3608 & 3609
> Connected to SQL instance using command prompt.
> Issued restore command but was met with this error:

Shared Memory Provider: The pipe has been ended.
Communication link failure

And found this in the SQL log..

2015-08-12 16:21:32.83 spid51 Starting up database 'tempdb'.
2015-08-12 16:21:36.88 spid51 Error: 3456, Severity: 21, State: 1.
2015-08-12 16:21:36.88 spid51 Could not redo log record (59:136:21), for transaction ID (0:0), on page (1:20), allocation unit 458752, database 'tempdb' (database ID 2). Page: LSN = (30:165:3), allocation unit = 458752, type = 1.

[Code] .....

View 9 Replies View Related

SQL Server Installation Corrupt Etc.

May 15, 2006

I'm using SQL 2005 Standard edition with Windows 2000 SP 4. Whenever Windows boots, I get this message 'SQL Server installation is either corrupt or has been tampered with (error getting instance ID from name). I've un-installed and re-installed SQL but I keep getting the same message. What's up with that? Is that a serious condition or should I ignore it? Any suggestions, anybody?

View 1 Replies View Related

Your SQL Server Installation Is Either Corrupt Or Has Been Tampered With....

Dec 25, 2005

Hi,I have just installed Microsoft Visual Web developer 2005 along with the Microsoft SQL Server 2005. Anyway, I tried to execute the SQL server(in directory ../Microsoft SQL Server MSSQL.1 MSSQL Binn) and it gave me this error:"Your SQL Server installation is either corrupt or has been tampered with (Error getting instance ID from name.). Please uninstall then re-run setup to correct this problem "I have formatted everything in my hard drive before re-installing Windows XP, and there isn't another SQL server except the one I just installed. If anyone could figure out what the problem is, can you please let me know how I could fix it?? Many many thanks.Nelson

View 1 Replies View Related

Corrupt Stored Procs On SQL Server 6.5

Jun 20, 2000

Hi

Recently I have experienced the following scary scenario;

Users report a problem with an app, on diagnosis it is found that a bunch of SPs in SQL Server seem to be corrupt.

That is, when the code for them is listed, the 'Create Procedure..' line and several DECLARE lines are missing. Often the SP starts off in the middle of a variable name!!

Perhaps entries in the syscomments table have become corrupted?

Has anyone seen this problem before - is it perhaps a known bug in SQL Server 6.5?

Regards,

View 1 Replies View Related

Troubleshooting A Corrupt Uninstall Of SQL Server

Apr 6, 2006

Hi --

I am a new user of SQL Server, Enterprise Manager, and Reporting Services (all three are installed on my comptuer) and have a problem. Please bear with me, I am very new at this and don't know all the correct terminology!

Someone in our IT group "discovered" that I had two "instances" of SQL on my machine. The way he came to this was that I was trying to use the "." to connect to my local machine in Query Analyzer and it wasn't pulling the databases I had saved to my computer, it was looking in another folder LOCALDB (a subset of my computer's name). He was unsure how to move all of my databases on my comptuer to that LOCALDB folder so he uninstalled the "LOCALDB" entry from the Add/Remove Programs screen to fix this. He said "No to All" when it prompted him to remove shared entries.

Consequently, when I load Enterprise Manager now, I get the "Snap-In failed to initialize" message. I also do not have any SQL Server options in my Start Menu Anymore. Query Analyzer still exists, though, I had saved a shortcut to my taskbar and I can still launch it from there. He is saying all I need is to re-install the "Client Tools" folder from the CD and that will fix the problem. I am skeptical, since it appears to be a larger issue (SQL isn't in my Start Menu anymore!).

I am sure that my SQL install is probably completely corrupt. I would like to return to full functionality of SQL Server, Enterprise Manager, and MRS as soon as possible. Can anyone begin to advise me on how to do so?

I really do appreciate your help in advance.
jzafereo

View 2 Replies View Related

Installing SQL Server 2005 Corrupt.

Sep 10, 2007



Hi,

I hope there is some body arround here to solve my problem.

After reinstalling SQL server 2005 I got this message:

Your SQL Server installation is either corrupt or has been tampered with ( Error getting Instance ID From name).
Please uninstall, then re-run stetup to correct this problem.

There are also 51 setup log files in: Setup/Boostrap/Log/files/


Can Ido that manually? Or is there another way to solve this problem.

Henk

View 11 Replies View Related

Your SQL Server Installation Is Either Corrupt Or Has Been Tampered With...

Dec 19, 2005

Hi

I have installed SQLExpress. Whenever I boot my PC (XP Pro SP2)  I get the following error just prior to logon: "Your SQL Server installation is either corrupt or has been tampered with (Error generating instance ID from name). Please uninstall the re-run setup to correct this problem."

I have now uninstalled and re-installed twice with no success. SQLExpress seems to be running fine, just this worrying message all the time.

Any help will be gladly appreciated.

Larry_t.

View 8 Replies View Related

Your SQL Server Installation Is Either Corrupt Or Has Been Tampered With

Feb 5, 2007

I got the above message when my system started.

I uninstalled everything, but had problems uninstalling the desktop engine. An attempts to reinstall just hung at "Please wait while Windows configures Microsoft SQL Server Desktop engine".

I used the MS recovery tool to remove the desktop engine.

After that running install would progress further thru the above dialog window, but then the progess bar just zipped backward and the dialog box disappeard. Nothing! No message or anything.

How do I clean up this mess?

Thanks,

-- Frank

View 2 Replies View Related

Error 2504 Server Table Corrupt

Dec 1, 1999

I have a table which I am unable to drop, remove indexes from, and when I select the database from the EM and click on Recalculate get the following error:

When attempting to do a Recalculate from the EM I get: Error 2541 (SQL Server) Table Corrupt object id does not match between extent in allocation page a d sysindexes; check the following extent; alloc pg# 589050 extent# 589096 object id on extent=0 object name=0 object id in sysindexes=1420532094 (object name=MifDEtailOct)

When attempting to remove an index from the table I get: Error 2504 (SQL Server) Table Corrupt index id in alloc page does not match the index id in sysindexes (alloc page#=721664; extentid=721704; index id in alloc=5;index id in sysindexes = 4

When attempting to drop the table from the EM it disappears then when I do a refresh it's back again.

I run a checkdb on the database once a week, but that hasn't resolved the problem.

I also ran the sp_fixindex as outlined in the faq with no relief.

This initially happened on one table and now I'm getting the same error on a second table. I have removed the data from both tables, but can't seem to get rid of them.

These tables originally has a couple of million records in them so they were rather large before I moved the data to a new table.

Truncate also didn't work when I was attempting to clear the table. I had to create an sp to delete a few hundred thousand records at a time.

I would appreciate any suggestions.

Rick Poland
rpolan1@tandy.com

View 1 Replies View Related

Corrupt Or Tampered With SQL Server File SQLEVN70.RLL

Mar 4, 2008

In doing a System Restore an error occurred in my SQL 2005. I've researched the thing, and am prepared to uninstall and reinstall SQL Server 2005, however, even tho I am administrator it will not uninstall. It will not reinstall over the previous install that's in place.

When I go through Control Panel to Add and Remove, when I click uninstall SQL Server 2005 it merely flashes a new window for a second and then does nothing. It will not start an uninstall action.

I don't know what to do short of a full XP Pro re-install.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved