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


ADVERTISEMENT

Database Crashed?

Nov 14, 2007

Hi,



I'm unsure what happened, but I'm using SQL Server 05 Developer Edition. I've been working with a local database where I tried to add a clustered index on a huge table (about 50M records). Well, I had to stop the query since it was maxing out my work computer. Since then, I've been unable to open the database or run queries against it.



When I open SQL Server Management Studio the database says In Recovery. Once it's done, when I try to expand tables, I eventually get this error:



TITLE: Microsoft SQL Server Management Studio
------------------------------

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

Lock request time out period exceeded. (Microsoft SQL Server, Error: 1222)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=1222&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------




If I run a Select * from INFORMATION_SCHEMA.TABLES query, it will go on for a while



If I try to access the properties of the Database (right clicking), I get this error:



TITLE: Microsoft SQL Server Management Studio
------------------------------

Cannot show requested dialog.

------------------------------
ADDITIONAL INFORMATION:

Cannot show requested dialog. (SqlMgmt)

------------------------------

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Lock request time out period exceeded. (Microsoft SQL Server, Error: 1222)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=1222&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------


I'm unsure where to go from this point forward.

View 7 Replies View Related

Help - Can't Connect To Database After Computer Crashed During Table Alteration

Mar 26, 2007

I was altering a few columns (setting to allow nulls) on a large table (30+ million records) and the machine naturally crashed. I rebooted, and now I can't connect to the DB - enterprise manager hangs, and query analyzer times out. is it likely the whole DB is screwed up, assuming the table alteration was incomplete?

thankfully, I do have a backup, but for future reference, is there a preferred way to make changes to large tables? last time I did this it took over an hour, and enterprise manager gives no progress indication to make me feel more comfortable that it's actually doing something...

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

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

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 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

Crashed MS SQL Server

Mar 2, 1999

Hi, Everyone:
We have two Domain T1&T2 that trusted each other's; one of SQL server of domain T2 has crashed. We rebuilt NT and SQL ver.6.5 with the same nameon the server of T2; we have the problem that crash server couldn't publish table to another server of T1. We got the error message:

08004(Microsoft)(ODBC SQL Server Driver)(SQL Server) Login failed-User:
T2_sqlexec Reason: Not defined as a valid user of a trusted SQL Server
connection.

We hope to get any help!! Thanks.

View 2 Replies View Related

Crashed Server.

May 6, 2008

Hi, i have a corrupt installation of SQL 7, so i am trying to attach the db's from that server to another, only it is not working. Is this soemthing that should be able to be done?

error message i get is:

Server: Msg 823, Level 24, State 1, Line 1
I/O error (bad page ID) detected during read of BUF pointer = 0x1159b2c0, page ptr = 0x205b6000, pageid = (0x1:0x9), dbid = 6, status = 0x801, file = C:MSSQL7Datacasenotes_Data.mdf.

Connection Broken

any help would be greatly appreciated.

View 13 Replies View Related

Server Crashed

Jan 5, 2006

Hi

I am using server 2000 , I question is - if server crashed then can we recover data.. how?


thanks

asm

View 4 Replies View Related

Crashed Db Recovery

Jul 26, 2007

Hello,

i've got MS Windows Server 2003 OS (RAID 10) and MS SQL 2005, however server crashed with "blue death" screen. After forced reset, SQL server marked my db as a SUSPECT. Tried DBCC CHECKDB with no luck, what can i do to bring it back to life, please? (have no backup).

Msg 926, Level 14, State 1, Line 1
Database 'IRIX' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information.
Msg 824, Level 24, State 2, Line 1
SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:182; actual 32:7602287). It occurred during a read of page (1:182) in database ID 5 at offset 0x0000000016c000 in file 'D:MSSQLIRIX.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
Msg 3313, Level 21, State 2, Line 1
During redoing of a logged operation in database 'IRIX', an error occurred at log record ID (844:9770:2). Typically, the specific failure is previously logged as an error in the Windows Event Log service. Restore the database from a full backup, or repair the database.
Msg 3414, Level 21, State 1, Line 1
An error occurred during recovery, preventing the database 'IRIX' (database ID 5) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support.
SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:182; actual 32:7602287). It occurred during a read of page (1:182) in database ID 5 at offset 0x0000000016c000 in file 'D:MSSQLIRIX.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
During redoing of a logged operation in database 'IRIX', an error occurred at log record ID (844:9770:2). Typically, the specific failure is previously logged as an error in the Windows Event Log service. Restore the database from a full backup, or repair the database.
An error occurred during recovery, preventing the database 'IRIX' (database ID 5) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support.
Cannot drop the table '#tmp_sp_db_vardecimal_storage_format', because it does not exist or you do not have permission. (Microsoft SQL Server, Error: 824)

View 3 Replies View Related

Upgrade Crashed Stored Procedures

Jun 21, 1999

We ran a test upgrade from SQL 6.5 to SQL 7.0. Everything worked great except we have one stored procedure (and it's an important one) which when run immediately after the upgrade, was fine. It ran in about 15 minutes which is normal.

However, when it was run the second time to retest it, it took 2-1/2 hours to run, then the third time it took almost 6 hours to run. There are no errors in the error log and I've used SQL Profiler to run on trace just on this stored procedure but it really doesn't show anything unusual except that it takes a long time to run this procedure.

The next step we took was to install SP1 thinking maybe there was a problem with a cursor, but that just seemed to make it worse.

Nothing else has changed. This stored procedure runs great on 6.5.

Does anyone have any clue why this might be happening. I dropped the procedure and recreated it, I've recompiled it, etc. and still the same results.

View 2 Replies View Related

SQL Server Crashed, DB Files Attached But ..

Dec 29, 2005

Hi, paws.
My server crashed recently, I didn't give to much importance because I knew that having access to the partitions I could recover my DB files and attach my database to my new server, and everything was fine until ... I found that my DTS Packages and Jobs where not in my Attached DB.
Now, where can I find these ?
Can you help a tormented man ?
Thanks in advance.

Francisco J

View 4 Replies View Related

Server Crashed/Need To Move SQL 2000 DB

Jul 20, 2005

We needed to replace our Motherboard on a server running win 2K Adv.Server with SQL server 2000. After replacing, we could not bringthe system back with the previous OS. So, we have decided tomigrate to Windows 2003 server and install SQL svr on it.On the old server, the SQL DB is residing on a seperate disk.Is there any way one can install SQL on the new server and importthe data from the disk. Many posts talk about how to do detach/attach etc.The case there is they have a running source server. In my case, I don't.any pointers will be appreciatedRegards,Anand

View 1 Replies View Related

Hard Drive Crashed. Master && User Db Mdf && Ldf Files Lost

Jan 31, 2006

Hello.

One of our hard drives has crashed and as a result we have lost our master mdf/ldf & user db mdf/ldf files. It's not that a critical system by any means, but if the hard drive crashes and the master mdf/ldf files & user db mdf/ldf are lost, is there any way of restoring the system?

I'm thinking we probably need to re-install Enterprise Manager completely, and re-install the user db from a backup.

Any advice/suggestions would be much appreciated.

Thanks in advance,

View 1 Replies View Related

When Using Data Source As Analysis Services Visual Studio 2005 Gets Crashed

Jan 8, 2008



Hi ,

I am using sql server 2005 standard edition and i have installed MSXML core services 6 and also ADOMD.net for analysis services.
i am using visual studio 2005 version of 8.0.5072742 and the problem that i am facing is when i use to develop reports using Analysis services as a data source , the error message pops up and VS 2005 gets crashed.

i could define the dataset , layout part and when i prees the preview , it gets crashed.
could any one help me on this problem to sort out.

Regards
RMP

View 1 Replies View Related

Corrupt

Oct 12, 2001

I found this script some where on internet..i am not sure what it does and how to i solve the problem because my friend has already run the script and i donno how to get back to the original configuration.

/* this script works on a database that is a copy of pubs. I created this database easily with DTS
This only works on SQL Server 7 databases
*/

/* NOTE: This script will truly corrupt a database. It should not be run on ANY real
database. It is only for simulating corruption for training purposes.

*/
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


How to sovlve the issue after the corrupt is done...how do i modify the info back to original..

Are there any other process or script that i can simulate to corrupt the databse and solutions pertaining to the same..i would like to experiment and then see how it goes and how quickly i can solve...

Thanks,

Jeff

View 2 Replies View Related







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