Corrupt Tempdb

Sep 14, 1999

I have been having problems with the SQL 7 server when temporary tables are being created, so I ran a DBCC checkdb against tempdb,
and this is what came back. When I try to run the dbcc with repair_allow_data_loss it says the database must be in single user mode.
This option is not allowed in tempdb. So now what? Does any one have any suggestions?

Server: Msg 8999, Level 16, State 1, Line 1
Database tempdb allocation errors prevent further CHECKDB processing.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:109) in database ID 2 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'IAM_PG MIXED_EXT ALLOCATED 0_PCT_FULL'.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:1000) in database ID 2 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:1016) in database ID 2 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
DBCC results for 'tempdb'.
CHECKDB found 3 allocation errors and 0 consistency errors not associated with any single object.
CHECKDB found 3 allocation errors and 0 consistency errors in database 'tempdb'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (tempdb ).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

View 1 Replies


ADVERTISEMENT

Corrupt Tempdb Table

Feb 10, 1999

I recieve a corrupt tempdb table when I run dbcc newalloc. Is there anything I can do other then restore from a backup.

View 6 Replies View Related

TempDB Corrupt - SSAS Usage

Oct 31, 2007

I'm hoping to find help here on the following issue. Here is the setup and situation. I'm running SQL Server 2005, including SSAS. SQL Server holds a database that is about 7GB in size and used to provide the data for my analysis project.

I successfully created cubes, deployed them and worked with them. Then all of the sudden I got error messages that all where related to tempdb and sounded like this:

<...
The operating system returned error incorrect page (expected 1:334039; actual 47:3211311) to SQL Server during a read at offset 0x000000a31ae000 in file 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATA empdb.mdf'
...>

I run DBCC but nothing came up (please see below). After searching for hours, I increased the initial size of the tempdb and restarted. It was at about 2GB and I brought it up to 4GB. At first it worked but would then fail again.

My best guess is that is has to do with the amount of dimensions and measures that I use in my cube but compared to what I keep reading it is still very small in size.

I have 4 dimensions, 1 with 3-5 attributes and maybe a 150000 rows total in the view I used. Some of the tables hold more records though (~3 million).

Could it by that my server is simply not fast enough (I/O) to keep up with whatever SSAS is doing? I have a hard time to believe that.

Here is what DBCC CHECKDB ('mbox', REPAIR_REBUILD) came back with on my work DB:
<....
DBCC results for 'mBOX'.
Service Broker MSG 9675, State 1: Message Types analyzed: 14.
Service Broker MSG 9676, State 1: Service Contracts analyzed: 6.
Service Broker MSG 9667, State 1: Services analyzed: 3.
Service Broker MSG 9668, State 1: Service Queues analyzed: 3.
Service Broker MSG 9669, State 1: Conversation Endpoints analyzed: 0.
Service Broker MSG 9674, State 1: Conversation Groups analyzed: 0.
Service Broker MSG 9670, State 1: Remote Service Bindings analyzed: 0.
DBCC results for 'sys.sysrowsetcolumns'.
There are 1208 rows in 11 pages for object "sys.sysrowsetcolumns".
DBCC results for 'sys.sysrowsets'.
There are 137 rows in 1 pages for object "sys.sysrowsets".
DBCC results for 'sysallocunits'.
There are 151 rows in 2 pages for object "sysallocunits".
DBCC results for 'sys.sysfiles1'.
There are 2 rows in 1 pages for object "sys.sysfiles1".
DBCC results for 'sys.syshobtcolumns'.
There are 1208 rows in 12 pages for object "sys.syshobtcolumns".
DBCC results for 'sys.syshobts'.
There are 137 rows in 1 pages for object "sys.syshobts".
DBCC results for 'sys.sysftinds'.
There are 0 rows in 0 pages for object "sys.sysftinds".
DBCC results for 'sys.sysserefs'.
There are 151 rows in 1 pages for object "sys.sysserefs".
DBCC results for 'sys.sysowners'.
There are 14 rows in 1 pages for object "sys.sysowners".
DBCC results for 'sys.sysprivs'.
There are 134 rows in 1 pages for object "sys.sysprivs".
DBCC results for 'sys.sysschobjs'.
There are 149 rows in 4 pages for object "sys.sysschobjs".
DBCC results for 'sys.syscolpars'.
There are 1089 rows in 20 pages for object "sys.syscolpars".
DBCC results for 'sys.sysnsobjs'.
There are 1 rows in 1 pages for object "sys.sysnsobjs".
DBCC results for 'sys.syscerts'.
There are 0 rows in 0 pages for object "sys.syscerts".
DBCC results for 'sys.sysxprops'.
There are 32 rows in 12 pages for object "sys.sysxprops".
DBCC results for 'sys.sysscalartypes'.
There are 27 rows in 1 pages for object "sys.sysscalartypes".
DBCC results for 'sys.systypedsubobjs'.
There are 0 rows in 0 pages for object "sys.systypedsubobjs".
DBCC results for 'sys.sysidxstats'.
There are 327 rows in 9 pages for object "sys.sysidxstats".
DBCC results for 'sys.sysiscols'.
There are 645 rows in 6 pages for object "sys.sysiscols".
DBCC results for 'sys.sysbinobjs'.
There are 23 rows in 1 pages for object "sys.sysbinobjs".
DBCC results for 'sys.sysobjvalues'.
There are 372 rows in 116 pages for object "sys.sysobjvalues".
DBCC results for 'sys.sysclsobjs'.
There are 16 rows in 1 pages for object "sys.sysclsobjs".
DBCC results for 'sys.sysrowsetrefs'.
There are 0 rows in 0 pages for object "sys.sysrowsetrefs".
DBCC results for 'sys.sysremsvcbinds'.
There are 0 rows in 0 pages for object "sys.sysremsvcbinds".
DBCC results for 'sys.sysxmitqueue'.
There are 0 rows in 0 pages for object "sys.sysxmitqueue".
DBCC results for 'sys.sysrts'.
There are 1 rows in 1 pages for object "sys.sysrts".
DBCC results for 'sys.sysconvgroup'.
There are 0 rows in 0 pages for object "sys.sysconvgroup".
DBCC results for 'sys.sysdesend'.
There are 0 rows in 0 pages for object "sys.sysdesend".
DBCC results for 'sys.sysdercv'.
There are 0 rows in 0 pages for object "sys.sysdercv".
DBCC results for 'sys.syssingleobjrefs'.
There are 154 rows in 1 pages for object "sys.syssingleobjrefs".
DBCC results for 'sys.sysmultiobjrefs'.
There are 317 rows in 2 pages for object "sys.sysmultiobjrefs".
DBCC results for 'sys.sysdbfiles'.
There are 2 rows in 1 pages for object "sys.sysdbfiles".
DBCC results for 'sys.sysguidrefs'.
There are 0 rows in 0 pages for object "sys.sysguidrefs".
DBCC results for 'sys.sysqnames'.
There are 91 rows in 1 pages for object "sys.sysqnames".
DBCC results for 'sys.sysxmlcomponent'.
There are 93 rows in 1 pages for object "sys.sysxmlcomponent".
DBCC results for 'sys.sysxmlfacet'.
There are 97 rows in 1 pages for object "sys.sysxmlfacet".
DBCC results for 'sys.sysxmlplacement'.
There are 17 rows in 1 pages for object "sys.sysxmlplacement".
DBCC results for 'sys.sysobjkeycrypts'.
There are 0 rows in 0 pages for object "sys.sysobjkeycrypts".
DBCC results for 'sys.sysasymkeys'.
There are 0 rows in 0 pages for object "sys.sysasymkeys".
DBCC results for 'sys.syssqlguides'.
There are 0 rows in 0 pages for object "sys.syssqlguides".
DBCC results for 'sys.sysbinsubobjs'.
There are 0 rows in 0 pages for object "sys.sysbinsubobjs".
DBCC results for 'UHISTFCST'.
There are 2798023 rows in 89218 pages for object "UHISTFCST".
DBCC results for 'SS'.
There are 0 rows in 0 pages for object "SS".
DBCC results for 'MODEL'.
There are 3 rows in 1 pages for object "MODEL".
DBCC results for 'MASKDATA'.
There are 15397 rows in 109 pages for object "MASKDATA".
DBCC results for 'MASK'.
There are 7328 rows in 44 pages for object "MASK".
DBCC results for 'LOC'.
There are 230 rows in 5 pages for object "LOC".
DBCC results for 'LINREGSTATS'.
There are 1285 rows in 59 pages for object "LINREGSTATS".
DBCC results for 'LINREGPARAM'.
There are 29192 rows in 1310 pages for object "LINREGPARAM".
DBCC results for 'HISTSTREAM'.
There are 2 rows in 1 pages for object "HISTSTREAM".
DBCC results for 'HISTFCST'.
There are 3827608 rows in 75573 pages for object "HISTFCST".
DBCC results for 'HIST'.
There are 1666993 rows in 44095 pages for object "HIST".
DBCC results for 'FCST'.
There are 2126837 rows in 27584 pages for object "FCST".
DBCC results for 'EVENT'.
There are 6 rows in 1 pages for object "EVENT".
DBCC results for 'DMDUNIT'.
There are 21661 rows in 981 pages for object "DMDUNIT".
DBCC results for 'DMDGROUP'.
There are 26 rows in 1 pages for object "DMDGROUP".
DBCC results for 'DFUTOSKU'.
There are 29192 rows in 490 pages for object "DFUTOSKU".
DBCC results for 'DFUMAP'.
There are 64957 rows in 1580 pages for object "DFUMAP".
DBCC results for 'DFU'.
There are 136963 rows in 9349 pages for object "DFU".
DBCC results for 'Locations'.
There are 247 rows in 2 pages for object "Locations".
DBCC results for 'DBPARAM'.
There are 1 rows in 2 pages for object "DBPARAM".
DBCC results for 'CALDATA'.
There are 88308 rows in 1066 pages for object "CALDATA".
DBCC results for 'CAL'.
There are 156 rows in 2 pages for object "CAL".
DBCC results for 'ALLOCSTRAT'.
There are 14 rows in 2 pages for object "ALLOCSTRAT".
DBCC results for 'sysdiagrams'.
There are 1 rows in 1 pages for object "sysdiagrams".
DBCC results for 'TOP5080'.
There are 1325 rows in 7 pages for object "TOP5080".
DBCC results for 'sys.queue_messages_1977058079'.
There are 0 rows in 0 pages for object "sys.queue_messages_1977058079".
DBCC results for 'sys.queue_messages_2009058193'.
There are 0 rows in 0 pages for object "sys.queue_messages_2009058193".
DBCC results for 'sys.queue_messages_2041058307'.
There are 0 rows in 0 pages for object "sys.queue_messages_2041058307".
DBCC results for 'MaterialMaster'.
There are 33426 rows in 3463 pages for object "MaterialMaster".
CHECKDB found 0 allocation errors and 0 consistency errors in database 'mBOX'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

....>

Now, it turns out my HD was really defragmented so I'm currently running a defrag but this is already driven by pure hope.

Sorry for the lengthy mail but I'm really hoping to find help around here.

Any suggestions is appreciated!

Happy halloween and regards,
Dirk

View 6 Replies View Related

Tempdb Is Skipped. You Cannot Run A Query That Requires Tempdb

Jul 14, 2004

Has anyone seen the SQL Server error:

"tempdb is skipped. You cannot run a query that requires tempdb"?

We're running a .Net web application with a SQL Server 2000 backend, and we get the error intermittently. Restarting the SQL Server service seems to fix it, as it causes tempdb to be rebuilt, but this isn't a long term solution. Any direction or hints would be greatly appreciated. Thanks!
- Mike

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

Corrupt Mdf?

May 27, 2003

The ldf file of a db was deleted by mistake. This was done whilst the SQL Server Service was still running. The db was not detached cleanly. I ran sp_detach_db on the db and tried re-attaching but got the error message:
"Database [dbname] cannot be opened because some of the files could not be activated".
Subsequently I have tried creating a new db called the same as the old one. Stopping the MSSQL service, copying over the mdf and re-starting the service. The db still comes up as suspect and the error log shows "Device activation error. The physical file name 'D:LogsETERBK_Log.LDF' may be incorrect". I have tried copying over the new ldf to the correct location but the same message appears.
I am not interested in getting the data back but would like to get back the stored procedures. Can anyone help this is urgernt?

View 8 Replies View Related

Corrupt SQL 2k DB, Need Help!

Jul 6, 2006

Have a corrupt SQL database that I am unable to repair using any of the repair options with DBCC CHECKDB. Below is the output from the repair_allow_data_loss option.

I can't seem to figure out how to go about fixing this. Any takers?!

Server: Msg 8946, Level 16, State 12, Line 2
Table error: Allocation page (1:24264) has invalid PFS_PAGE page header values. Type is 0. Check type, object ID and page ID on the page.
Server: Msg 8921, Level 16, State 1, Line 1
CHECKTABLE terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:24264). 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:24264). 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:24264). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 0 and 8192.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:24264). 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:24264). 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:24264). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 0 and 8192.
Server: Msg 8998, Level 16, State 1, Line 1
Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to verify database ID 7 pages from (1:24264) to (1:32351). See other errors for cause.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 0, index ID 0, page (1:32352). 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:32352). 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:32352). Test (m_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)PAGESIZE - m_slotCnt * sizeof (Slot)) failed. Values are 0 and 8192.
Server: Msg 8998, Level 16, State 1, Line 1
Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to verify database ID 7 pages from (1:32352) to (1:40439). See other errors for cause.
DBCC results for '8602955'.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The repair level on the DBCC statement caused this repair to be bypassed.
The system cannot self repair this error.
The system cannot self repair this error.
The repair level on the DBCC statement caused this repair to be bypassed.
The system cannot self repair this error.
The system cannot self repair this error.
The system cannot self repair this error.
The repair level on the DBCC statement caused this repair to be bypassed.
CHECKDB found 8 allocation errors and 3 consistency errors not associated with any single object.
DBCC results for 'sysobjects'.
There are 1395 rows in 27 pages for object 'sysobjects'.
CHECKDB found 8 allocation errors and 3 consistency errors in database '8602955'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

View 20 Replies View Related

Corrupt Table

Aug 24, 2006

I have a table that I can't read any data. 
It hangs up when I try to drop it as well.
 
So, what are my options here?  Secondly, what has caused this?

View 5 Replies View Related

Corrupt Master DB

Feb 7, 2002

I had installed a third-party software on my server and that corrupted my Master DB. Over the weekend when we bought SQL server down, we could not bring it back up. I had to re-install SQL server and then restore all my databases from the backup. Is there a better way of doing this???
Curiously
Someone who calls himself a DBA

View 4 Replies View Related

Backup Job Corrupt ???

Jul 23, 2002

Hi everybody,

I have a strange problem with one of the jobs created through a maintenace plan. The idea is that every 2 hours a transaction log backup is created and backups older than 2 days should be removed. This worked for several months without a problem, but suddenly today the job reports failed as status.

I looked into jobhistory but all I got is the following message:

sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.

Strange enough reports the sqllog that the t-log has been backed up succesfully. The files are on disk and I can restore them without a problem.

Any ideas what is going on ???

Tia Markus

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

Table Corrupt- Help

May 30, 2001

Hi,
One of my tables got corrupt and it is not possible to bring down the Database into Single user mode to run the dbcc to repair it. Is there any other way that I could correct.

Thanks
Cynthia

Msg 8978, Sev 16: Table Corrupt: Object ID 901630305, index ID 8. Page (5:572498) is missing a reference from previous page (8:98777). Possible chain linkage problem. [SQLSTATE 42000]
Msg 8928, Sev 16: Object ID 901630305, index ID 8: Page (8:98777) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8976, Sev 16: Table Corrupt: Object ID 901630305, index ID 8. Page (8:98777) not allocated or corrupt. Parent (5:335525) and previous (5:572497) refer to it. [SQLSTATE 42000]
Msg 8944, Sev 16: Table Corrupt: Object ID 901630305, index ID 8, page (8:98777), row 38. Test (VarColOffsets + (int)(sizeof (class VarColOffset) * nVarCols) <= (nextRec - pRec)) failed. Values are 525 and 26. [SQLSTATE 42000]

View 3 Replies View Related

Corrupt Table

May 23, 2000

What is the best approach to repairing a corrupt table? I received the following error from last night's maintenance. (SQL 6.5)

Thanks, Kevin

[2] Check Data Allocation...
WARNING: Database AHSDATA is currently being used by 1 user(s).
This may cause spurious problems to be reported.

The following errors were found:

Table Corrupt: object id does not match between extent in allocation page and Sysindexes; check the following extent: alloc pg#=247552 extent#=247720 object id on extent=-1175060352 (object name = -1175060352) object id in Sysindexes=1329491865 (object name = PS_AHS_RETIRE_2000)

Table Corrupt: Index id on extent should be 0; check the following page and ids: alloc page=247552 extent=247720 index id on extent=200

Table Corrupt: Extent structures are linked incorrectly; check the following extent: alloc pg#=247552 extent#=247720 previous extent# on this extent=-1 previous extent should be=247712

Table Corrupt: Object id wrong; tables: alloc page 247552 extent id=247720 l page#=247720 objid in ext=-1175060352 (name = -1175060352) objid in page=1329491865 (name = PS_AHS_RETIRE_2000)objid in sysindexes=1329491865 (name = PS_AHS_RETIRE_2000)
** Execution Time: 0 hrs, 10 mins, 50 secs **

[3] Update Statistics...
[Microsoft SQL-DMO] Error 605: [SQL Server] Attempt to fetch logical page 247792 in database 'AHSDATA' belongs to object 'PSPNLDEFN', not to object 'PS_AHS_RETIRE_2000'.
[Microsoft SQL-DMO] Error 10025: [DB-Library] Possible network error: Write to SQL Server Failed.

** Execution Time: 0 hrs, 5 mins, 11 secs **

View 4 Replies View Related

Corrupt Index

Apr 6, 2000

Hi,

I am receiving an Msg 2540 on a database when I perform the DBCCs. It looks like the indexes on this one table got corrupt. I know this because when I perform the DBCCs with the noindex option then I do not get any errors. I tried to drop and recreate the indexes (two indexes - one clustered and one unique) but to no avail. The dbccs continued to produce the error.

If someone has any ideas please respond. This is a prodn problem and so any input would be greatly appreciated.
Thanks again
Kiran

View 1 Replies View Related

Table Corrupt

Jan 17, 2000

I have a problem for dropping a table from my database and I got the error message: ""Extent chain for object 736005653 is not correctly linked." The problem indicates table corrupt on the database from DBCC checknewalloc. Instead of reloading the database from a dump, do you have anyway to repair the damage table or drop it.

TIA,

Stella Liu

View 1 Replies View Related

Table Corrupt

Dec 25, 1999

I am running SQL server 6.5 with sp3 on NT4.0 with sp6. I ran DBCC checkalloc on one of my database and got the following message.

Table Corrupt: Extent structures are linked incorrectly; check the following extent: alloc pg#=6815488 extent#=6815736 previous extent# on this extent=8625424 previous extent should be=6815728

I have previouly ran dbcc checkdb on the database and I was not able to correct the problem. Please help!

View 1 Replies View Related

LRU List Is Corrupt.

Apr 12, 1999

This morning no one was able to connect to the SQL server. At the server, the RAID set showed no activity. I could not bring up any applications. When clicking the start button, it would take 5 minutes to get a response. I connected to the server from a different machine and tried to restart the SQL services, without success. I could access the Event Viewer Application log. All entries in the log read "DB-LIBRARY error - SQL Server connection timed out." The SQL error log listed the following error " Lazywriter: LRU list is corrupt, bhead 0xe50040, bnew 0, bold 0x130bb00, stat 0x1004/0, page 0x1e1608, bufno 0, freebufs 5528, freelist 0xf1bfe0
99/04/10 22:22:10.10 spid2 Lazywriter: LRU list is corrupt, bhead 0xe50040, bnew 0, bold 0x130bb00, stat 0x1004/0, page 0x1e1608, bufno 0, freebufs 5498, freelist 0x118274"

What does this error indicate? We have received this error in the past and have upgraded our RAID controller because. This is the first time we have had this error since upgrading the controller a month ago.

Thanks.

Philip Talavera
System Administrator
SVG Distribution

View 2 Replies View Related

Msdb Corrupt

Apr 28, 1999

After implementing a recommendation to perform dbcc checkalloc before nightly backup, I began getting the error below on msdb. Books Online suggests restoring from a known clean backup. We have only been using SQL Server for a few weeks and it seems that all our backups of msdb have the same problem. Is there any way of correcting this problem?


Msg 2521, Level 16, State 1
Table Corrupt: Page is linked but not allocated; check the following pages and table: alloc page#=3584 extent id=3816 logical page#=3816 object id in extent=8 (object name = syslogs) index id in extent=0

View 2 Replies View Related

How To Corrupt Files

Jul 11, 2002

Hello!

I'm intrested in all possible ways to corrupt data or log files in SQL server 2000 except of manualy editing them or cutting the comp's power abruptly.

Thank you.

View 1 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 Table

Mar 12, 2001

I run a daily maintaince job and it fails.But when i go through the error log. i get
this eror "'Table Corrupt: Extent id 30464 on allocation pg# 30464 has objid 732178004 and used bit on, but reference bit off"
how do i get the table name fron sysobjects as i have had no luck when i do a simple select query to get the details i need

Getting the name would make it easier to solve the problem
thanks

safac

View 1 Replies View Related

Corrupt Syslogs

Jun 23, 2004

hello everyone,
how can i fix my corrupt syslogs? i've tried dbcc checktable , dbcc checkalloc, and dbcc fix_al and still reports the same message.we're using ms sql 6.5. PLEASE HELP!

View 3 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 Indexes

Oct 11, 2005

Hi

I have a table that keeps getting corrupt all the time. If I do a dbcc checktable, it says the primary key is corrupt. I can fix this by dropping the PK and creating it again, then the table is fine for a while. Problem is, this keeps happening every week! It's quite a big table (15.8 mil records), so this is timeconsuming to drop and recreate PK...

When trying to query the table, it returns the following error:
Attempt to fetch logical page (1:680898) in database 'dbCustomer' belongs to object 'tblPlayer', not to object 'tblTransactions'.
tblTransactions is the table that gets currupt.
The logical page number is different every time as well, so it's not the page it self causing the problem.

The table is updated via transactional replication. The source is in Cape Town, South Africa and the destination in Canada, North America. We do have many other tables being replicated in this manner for many years, but none have given this problem before.

Does anyone have some advice as to what I need to look at maybe? I'm not really sure where to start looking for the cause of the problem.

Thanks,
TeaaZA

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

INDEX CORRUPT

May 17, 2008

Dear All,
i made full-text index on one table.while i run a query using Contains clause the following error occurs,

Server: Msg 7619, Level 16, State 1, Line 1
The content index is corrupt.


How can solve this Problem without down the Sql Server 2000, this is happend me very frequently. once i restart the System ,it would be okay.

THanks

M A Sulaiman

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

Possible Corrupt Function ?

Mar 27, 2008

Hello,

I have a function on my DB that appears to be corrupt.
Basically it won't let me make a change to it (It simply hangs on the hourglass)

I've also tried deleting the function, but again it hangs on the hourglass.

Does anyone know how I can get rid of this function and replace it with a copy ?

View 10 Replies View Related

Possible Corrupt Table

Jul 20, 2005

I have 1 table in a 200+ table databaseThe database is Merge Synchornised and has been working fine for 2years +The same database is at several customers and the DB is fullyrelationalI have a table which creates client timeout errors whenever an insertor update is issuedThe table has foreign keys and primary key and links parent tochildren tables so if I need to recreate the table I will also needadvice on the best way to do this to keep the integrity of thedatabaseI wasn't sure the table was the problem so I deleted all publicationsand disbled the server from being a distributorI cannot find any error logs with any clues so can only assume the isthe first corruption I have ever seen on SQL 2K (SP3)I have defragmented the drive, reindexed the tables, shrunk databases(Plenty of space available)Please advise any course of action you think may help me.Regards Paul Goldney

View 1 Replies View Related

Attach DB With Corrupt .ldf?

Jul 20, 2005

Hey gang,I've been trying to restore a DB from it's MDF and LDF all morning;the catch? The LDF appears to be corrupt.When I first started the SQL Server, the db in question was marked as"Suspect'. I did some research on this and it has caused me to attemptdetaching, backing up, deleting the LDF, using ATTACH DB and evensp_attach_single_file_db, and sp_add_data_file_recover_suspect_db.Nothing works.So, with an MDF and no LDF ... is it possible to recreate thisdatabase somehow? Can I attach the MDF to another (empty) database toretrieve it's contents? (Tried it, couldn't get it to work), can Iextract the contents of the MDF - even if it's just the objects andnot the data itself - in some capacity?I've read in various places about attaching an MDF with no LDF and thesystem will recreate the LDF as needed, but that doesn't work either.Ideas are most, most, most welcome.

View 1 Replies View Related

Corrupt Of Csv File

Feb 4, 2008

I have a SSIS package that reads a SQL database and generates a flat file(.csv ) in some other system. This flat file is being read by another software tool to do further processing. The package is scheduled as SSIS job.I deployed in the production around 1 month back and it was working fine. Around 1 week back, there was a job failure for the SSIS package. The error log suggested that the problem is with some buffer management and temp file usage in the system where the csv file is generated. The error was rectified by giving appropriate permissions to the folder and temp area to the user that is running the SSIS job on the sql server. After that, the job has run successfully and the csv file is also generated. The format of the csv file seems to be correct. But however, the third party software tool is not being able to read the file treating it as invalid file.

I have no access to the production environment. Can anyone suggest is to do anything with the SSIS package and how can the issue be resolved?

Any help would be highly appreciable.


Many Thanks
Debanjan

View 3 Replies View Related







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