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
ADVERTISEMENT
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
View Related
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
May 27, 2008
Hi,
My problem is the following:
tempdb is currently 20Gb data space and still some applications request more space :eek: .
Since this server contains multiple applications, I'd like to isolate the application
that uses most tempdb space / get a detailed view on who is using what.
It would be ideal if there was a way to find the SQL / temp table
that cause the problem.
Can anyone help me with this problem.
Thanks
Alren
View 6 Replies
View Related
Jul 21, 2015
I received an alert from our alerting system that log space for tempdb is used over 60%.
My question is what options do I have to troubleshoot and fix it? If it would be a regular user database, I would check for log_reuse_wait_desc in sys.databases, run another log backup, and maybe some other things. But what I can do with tempdb?
View 5 Replies
View Related
Apr 10, 2015
I can get a snapshot of tables in tempDB, but I would like to track which procs are causing the load in the tempDB.
I think I can sample and record objects in the tempdb, but I would like to record the proc creating the most tempDB usage, and disk read/writes associated with those procs.
The DMV's give usage in the individual DB's, but what's a good way to correlate procs in the DB's to tempdb usage?
View 9 Replies
View Related
Jun 15, 2015
today I've put in production a big database accessed by 200 concurrent users, this database has READ_COMMITTED_SNAPHOT set to ON.I know that RCSI set to ON is very aggressive on tempDB so I'm monitoring it.I've noticed that the Transaction log space usage (%) on TempDB is slowly but ever increasing, I mean in the last 24 hours I've started from a 99% space free, now we are 37% space free...is it normal? TempDB log is 35GB in size.
View 6 Replies
View Related
Jun 16, 2014
The TEMPDB transaction log file keeps growing.The database server is new and the transaction log was presized to 1 GB on installation. After installing a number of databases, the log file grew over a day to 38GB. Issuing a manual checkpoint was the only way to free some space to allow it to be shrunk back to a usable size. The usage of the file is still going up.
I am struggling to find what process is causing the log to be used so heavily. Looking at the log reuse wait desc for tempdb returns "Nothing" and tempdb itself isn't being used very much or growing in size.
View 9 Replies
View Related
Nov 2, 2007
I have a client program that writes to sql server database 10 records per second . i want to compute the CPU usage and the memory usage for the whole program or CPU usage,memory usage for the insert statement in the program .
Can anybody help me with this?
View 6 Replies
View Related
Sep 7, 2007
Hello, When I am seeing SQL Server 2005 Management studio Server Dashboard> I am seeing my(USERS) databases and msdb database usage is very small % of in CPU Usage(%), Logical IO Performed (%) Usage pie chart.
90% of Total cpu usage is showing for Adhoc Queries. what excatly this means in Dashboard? if application uses more than it would have shown in Database level or not?
sicerely this dashboard is good, if any one is watching daily, please advice their experiences here.
Thanks in advance. Hail SQL Server!
View 3 Replies
View Related
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
Jan 30, 2014
providing a query for fetching the data for CPU Usage, Memory usage, blocking and all details ...
I want to create a job which will run on a Node every 15 min and store data in a table for each instance...
DMV is not giving more stuff and xtended events not sure if i can store that data into a table?
View 7 Replies
View Related
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
