Problem With CheckDB - SQL Server 2005
Mar 27, 2008
I've just converted from SQL Server 2000 to 2005 and I'm encountering a few issues, as would be expected when migrating from one environment to another.
In particular, I have a service which periodically issues a simple "DBCC CheckDB" during the day against a database which is constantly in use. With SQL Server 2000, everything worked fine. On my station which has SQL Server 2005 Developer edition, again everything is working fine. However, on a test station which has SQL Server 2005 Express, the operation fails with "The database could not be exclusively locked to perform the operation.".
Given that I'm not requesting any tab locks, I suppose that the exclusive locks are being required because a snapshot cannot be created. Question is: why on SQL Server Express and not anything else? Is this a configuration issue?
Any thoughts would be appreciated.
View 8 Replies
ADVERTISEMENT
Mar 26, 2007
Hi,
We are running 2005, 9.00.2047.00, and getting a consistency error on sys.sysschobjs. The system is running fine as far as I can tell. I don't see any documentation on how to repair the object, nor can I access it directly. Any suggestions/procedures on how fix it? If I leave it the way it is will what are the ramifications later on? Please find more detail on the CHECKDB error below.
Thanks for the help.
Rick
======================================================================
Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86)
Apr 14 2006 01:12:25
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
Msg 2570, Sev 16, State 3, Line 17 : Page (1:1103587), slot 24 in object ID 34, index ID 1, partition ID 281474978938880, alloc unit ID 281474978938880 (type "In-row data"). Column "modified" value is out of range for data type "datetime". Update column to a legal value. [SQLSTATE 42000] Msg 8990, Sev 16, State 1, Line 17 : CHECKDB found 0 allocation errors and 1 consistency errors in table 'sys.sysschobjs' (object ID 34). [SQLSTATE 01000] Msg 8989, Sev 16, State 1, Line 17 : CHECKDB found 0 allocation errors and 1 consistency errors in database 'DV1'. [SQLSTATE 01000]
Job 'Check Database DV1 [20060816141231-0-030000]' : Step 1, 'Step1' : Began Executing 2006-08-18 03:00:00
DBCC CHECKDB (DV1) started at Aug 18 2006 3:00AM with Logfile: F:Program FilesMicrosoft SQL ServerMSSQL.1
View 9 Replies
View Related
Apr 17, 2007
Hi to all,
We have an environment production with a lot of activity all days,
for this reason the time for the maintenance tasks is very short (only
for Reindex and no more).
We must execute all days a DBCC CheckDB command without to affect
the performance server and we have a problem with the temporally
snapshot that is create during this command because usually we have
some load tasks executing at the same time of the DBCC and the size of
the snapshot is too big and produce an error for not enough space on
the disk.
In some documents we have read that when you have an environment
with non NTFS disks the command work like on SQL Server 2000 without
snapshot.This is not our case because we have NTFS disks but we would
like to execute the command without snapshot, with database online and
compatibility level option to SQL Server 2005 (9.0).
Someone know if this is possible?
Thanks in advance,
Prado
View 4 Replies
View Related
Aug 9, 2006
I can run that command easily for a single DB and then manually copy/paste that command (and change the database name each time) but does sql have a way to loop through all databses on a server?
TIA,
barkingdog
View 6 Replies
View Related
Dec 8, 2014
I have huge database on prod. One time I tried to run DBCC CHECKDB, it took more than a day. My question is can I created a snapshot of the prod database on the same server and run DBCC CHECKDB on the Snapshot DB? will doing this interfere production database? I don’t have option to make copy of the database on a test server and run it there.
View 9 Replies
View Related
Jun 3, 2015
We carried out an in-place upgrade on our production server on Saturday - going from 2008 R2 to 2014.
We had tested this method out in dev/test and pre-production with only minor post issues to fix.
However, on production we had an issue whereby checkdb was hitting 100% CPU and caused overnight processes to hang. The checkdb statement was terminated and disabled by a colleague at 1 am.
Since then we have restored this database to a dev server and ran checkdb against it with no_infomsgs and all_errormsgs but it still hasn't finished since Monday morning!
The database is just over 800 GB and whilst checkdb was crippling the cpu, logical reads are less than one. However, sp_whoisactive is showing that it has done 56 million reads so far and this number increases periodically so it looks like it keeps going back to re-check the database with a deep dive.
Also, on a different environment, we ran check table statements and one of them took over 9 hours for a single table but came back clean (see attachment).
We need to wait for the output but the database is still in use in production and the mess will just get worse if it is indeed corrupted.
View 5 Replies
View Related
Sep 8, 2015
I have an issue with DBCC Check DB maintenance plan . I run it in my production last nite.
After running for 1 hour , the package failed ( the step failed )
As below :
Executed as user: ETSPDCSQL1-VWSYSTEM. ....0.5500.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 22:06:13 Progress: 2015-09-08 22:06:14.11 Source: {F0BABEC1-ECBF-4B7D-86BE-7C2C99A08ED8} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp...".: 100% complete End Progress
[Code] .....
View 9 Replies
View Related
Jan 27, 2000
I have a few extremely large databases in SQL Server 6.5 sp3
(soon to be 5a - but we won't talk about that!!) NT 4.0 sp4
(about 10 GIG each). I don't have a big window of down-time
in order to do any maintenance. Does anyone know of a way to
be able to run dbcc checkdb or other dbcc's that I can run to
verify the database yet complete within a reasonable amount
of time? The last time dbcc checkdb was run, it was started
Friday night and still not complete Sunday night.
Over a weekend, I may have up to a 24 hour maintenance window.
Any suggestions would be appreciated.
Thanks!
Toni
View 1 Replies
View Related
Nov 9, 1999
Hai ,
When I ran DBCC CHECK DB of userdatabase, its reporting along with usual messages as
Descriptor for system table '8' in database '8' not found in the descriptor hash table.
I could'nt understand being familiar error encounterd .
Any one will appreciate for the help
Thank you
View 1 Replies
View Related
Jan 17, 1999
Hello All,
I recently took over a SQL server with 300 MB of data. I am relatively new to SQL 6.5 and have been reading that DBCC checkdb and checkalloc should be run at least once per week. Apparently the person before me never ran any of those checks. Is not running the database consistency checks for so long going to present a problem? has anyone run into problems when running those checks? Any advise is greatly appreciated.
Pauli
View 4 Replies
View Related
Aug 28, 2006
I ran "dbcc checkdb(MCMSdb) with no_infomsgs" and I get the following:
Server: Msg 8946, Level 16, State 12, Line 2
Table error: Allocation page (1:274992) has invalid PFS_PAGE page header values. Type is 0. Check type, object ID and page ID on the page.
What cane be done to correct this problem?
Can this error prevent a user from connecting to the database?
View 3 Replies
View Related
Oct 25, 2006
hi guys
I ran checkdb and found 4 error message on the db.. it seen like same object.. can anyone tell me what it is.. and how can i fix it? thanks !!!!
1.
Server: Msg 8976, Level 16, State 1, Line 35
Table error: Object ID 2094630505, index ID 1. Page (1:809859) was not seen in the scan although its parent (1:77885) and previous (1:809767) refer to it. Check any previous errors.
2.
Server: Msg 8978, Level 16, State 1, Line 35
Table error: Object ID 2094630505, index ID 1. Page (1:809860) is missing a reference from previous page (1:809859). Possible chain linkage problem.
3.
Server: Msg 8976, Level 16, State 1, Line 35
Table error: Object ID 2094630505, index ID 1. Page (1:1453795) was not seen in the scan although its parent (1:1453347) and previous (1:1453796) refer to it. Check any previous errors.
4.
Server: Msg 8978, Level 16, State 1, Line 35
Table error: Object ID 2094630505, index ID 1. Page (1:1453801) is missing a reference from previous page (1:1453795). Possible chain linkage problem.
View 2 Replies
View Related
Dec 8, 2006
Hi All,
Does anybody know if the results of DBCC CHECKDB are stored anywhere? If yes, where?
Also, if you don't select "attempt to repair minor problems" option when you set up the maintenance plan, will SQL Server let you know about any errors Integrity check encounters? If yes, where the erros can be found?
Thanks.
View 10 Replies
View Related
Jul 12, 2001
Hello all,
in the SQL 6.5 documentation it says when running the DBCC CHECKDB, you should make the database read Only or DBO use only. Do you guys know if SQL 6.5 locks rows while this runs? In SQL 7.0/2000 it only locks the schema.
Thanks,
Lee E. Smith
View 1 Replies
View Related
Nov 11, 1998
I am using windows nt40 and sql server 6.5 on a DEC ALPHA and accidentlly
started a dbcc checkdb. Is it possible to stop the process with out damaging the database?
View 1 Replies
View Related
Nov 8, 2000
When running dbcc checkdb from my workstation(nt) I recieve some of
the output and then I get "Connection Broken" this is on a 6.5 machine
with the service pack 5, what could be causing my ODBC connection to drop
during the proccess of running checkdb?
Kevin
View 1 Replies
View Related
Dec 12, 2006
Hi All,
How can I make the dbcc checkdb fail so I can get the errors displayed in the report log? DBCC Checkdb is the step in the integrity job that I run once a month. What I am trying to do is when the dbcc checkdb fails for any reason, I want to get notified so I can correct the problem. I don't want to use repair fast or any other repair parameters that you can select when you run dbcc checkdb function because most of my dbs are 24x7.
Thanks.
View 12 Replies
View Related
Jul 5, 2007
How often do you run it in your shop?
I'm seeing (from the new SQL Best Practices Analyzer) that MS recommends that it be done once every two weeks on SQL 2005.
I have never been in the habit of running it in production. I have never experienced database corruption in any form.
Just curious.
Regards,
hmscott
View 4 Replies
View Related
Aug 6, 2007
Hi All,
I have a job set up that runs the dbcc checkdb and puts the results into a table. Then I run a query against this table to check the results of dbcc checkdb. If there are errors, I get a page that lets me know that there are some problems. When I ran this job on my production server, the job failed stating that there are problems with data integrity. So I copied this db to a dev server and recreated the job just like I have in prod. The job completed successfully withou any errors. Can anybody tell me what to look at to figure out why it failed on the prod server?
Thanks.
View 4 Replies
View Related
Jul 11, 2005
Madhur writes "Last week DBCC CHECKDB <database name> took 2 Hrs to complete on a database.
Today again i have started but with the following command:
dbcc checkdb (<database name>, REPAIR_FAST ).
It is now running for more than 2.5 Hrs now.
Does the execution time increases even when the DB is consistent?
Can we cancel the execution in the middle? What consequences it may have on the db?
Thanks in advance."
View 2 Replies
View Related
Aug 12, 2005
I have a db that is about 50Gigs. Last night it went into a suspect mode and I have not been able to get any of my tables to display. I am running the dbcc checkdb. I have been running it for over 7 hrs. Do you have any suggestions as to what I should do or do you have any ideas as to how long this process might take?
thanks,
View 4 Replies
View Related
Sep 5, 2005
Ricardo writes "We are consistently getting this error. We have check the hardware and nothing appears in the checkdk, can you help.
Thanks
Ricardo
dbcc checkdb (virtualrequest)
DBCC results for 'tblVRAnswers'.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 370256524, index ID 3: Page (1:243518) could not be processed. See other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 370256524, index ID 3, page (1:243518). Test (IS_ON (BUF_IOERR, bp->bstat) &&bp->berrcode) failed. Values are 2057 and -1.
There are 9608 rows in 106 pages for object 'tblVRAnswers'.
CHECKDB found 0 allocation errors and 2 consistency errors in database 'VirtualRequest'.
dbcc checkdb (virtualrequest)
DBCC results for 'tblvrquestions'.
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'VirtualRequest', index 'tblVRRequestedItems.IX_NC_tblVRRequestedItems_CurrentStatusID' (ID 784825958) (index ID 2). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:214293:372) with values (CurrentStatusID = 3 and RequestedItemID = 413260) points to the data row identified by ().
There are 6614 rows in 103 pages for object 'tblvrquestions'.
CHECKDB found 0 allocation errors and 1 consistency errors in database 'VirtualRequest'
dbcc checkdb (virtualrequest)
DBCC results for 'tblvrquestions'.
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'VirtualRequest', index 'tblVRRequestedItems.IX_NC_tblVRRequestedItems_CurrentStatusID' (ID 784825958) (index ID 2). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:214293:372) with values (CurrentStatusID = 3 and RequestedItemID = 413260) points to the data row identified by ().
There are 6614 rows in 103 pages for object 'tblvrquestions'.
CHECKDB found 0 allocation errors and 1 consistency errors in database 'VirtualRequest'."
View 1 Replies
View Related
Jul 27, 2006
Hi,
Ran DBCC CHECKDB on my database and it's returning the following:
There are 460 rows in 13 pages for object 'KPW'.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1977058079, index ID 0: Page (1:1868079) could not be processed. See other errors for details.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 1977058079, index ID 0, page (1:1868079), row 76. Test (!(hdr->r_tagA & (VERSION_MASK | RECTAG_RESV_A | RECTAG_RESV_B))) failed. Values are 173 and 193.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 1977058079, index ID 0, page (1:1868079), row 76. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 16374 and 33.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1977058079. The text, ntext, or image node at page (1:1867931), slot 8, text ID 205274873856 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1977058079. The text, ntext, or image node at page (1:1867932), slot 0, text ID 205275004928 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1977058079. The text, ntext, or image node at page (1:1867932), slot 2, text ID 205275136000 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Suggestions on how to troubleshoot/fix?
Thanks!
View 19 Replies
View Related
May 7, 2007
Hi, I'm hoping somebody can help with an error received when actions are performed on any record. The error is received in a front end program that we cannot get support for. I'm not too familiar with SQL Server but can get by, does anybody have suggestions? Thanks
S1000:[Microsoft]pODBC SQL Server DRiver][SQL Server]Could not find the index entry for RID '16565ba0100' in index page [1:66796], index ID 0, database 'db1'.
The results found from checkdb are:
DBCC results for 'DB1'.
DBCC results for 'sysobjects'.
There are 155 rows in 3 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 300 rows in 14 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 1327 rows in 24 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 127 rows in 15 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 49 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 0 rows in 0 pages for object 'sysproperties'.
DBCC results for 'sysdepends'.
There are 309 rows in 1 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 0 rows in 0 pages for object 'sysreferences'.
DBCC results for 'sysfulltextcatalogs'.
There are 0 rows in 0 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 'F_Company'.
There are 0 rows in 0 pages for object 'F_Company'.
DBCC results for 'F_Cr_Detail'.
There are 222 rows in 21 pages for object 'F_Cr_Detail'.
DBCC results for 'F_Department'.
There are 6 rows in 1 pages for object 'F_Department'.
DBCC results for 'F_Document'.
There are 0 rows in 0 pages for object 'F_Document'.
DBCC results for 'F_Entry'.
There are 231241 rows in 2387 pages for object 'F_Entry'.
DBCC results for 'F_GL_Asset'.
There are 0 rows in 0 pages for object 'F_GL_Asset'.
DBCC results for 'F_GL_Body'.
There are 2 rows in 1 pages for object 'F_GL_Body'.
DBCC results for 'F_Letter'.
There are 100 rows in 2 pages for object 'F_Letter'.
DBCC results for 'F_Pm_Allocate'.
There are 0 rows in 0 pages for object 'F_Pm_Allocate'.
DBCC results for 'F_Pm_Auto_Entry'.
There are 3 rows in 1 pages for object 'F_Pm_Auto_Entry'.
DBCC results for 'F_Pm_Expense'.
There are 13 rows in 1 pages for object 'F_Pm_Expense'.
DBCC results for 'F_Pm_Job_Type'.
There are 0 rows in 0 pages for object 'F_Pm_Job_Type'.
DBCC results for 'F_Pm_Key'.
There are 2408 rows in 15 pages for object 'F_Pm_Key'.
DBCC results for 'F_Pm_Landlord'.
There are 1560 rows in 84 pages for object 'F_Pm_Landlord'.
DBCC results for 'F_Preferences'.
There are 0 rows in 0 pages for object 'F_Preferences'.
DBCC results for 'F_Printer'.
There are 0 rows in 0 pages for object 'F_Printer'.
DBCC results for 'F_Reports'.
There are 1 rows in 1 pages for object 'F_Reports'.
DBCC results for 'F_Suburb'.
There are 18 rows in 1 pages for object 'F_Suburb'.
DBCC results for 'F_System'.
There are 1 rows in 1 pages for object 'F_System'.
DBCC results for 'F_TaskType'.
There are 2 rows in 1 pages for object 'F_TaskType'.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1205579333, index ID 0: Page (1:66796) could not be processed. See other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 1205579333, index ID 0, page (1:66796). Test (m_freeCnt == freeCnt) failed. Values are 8 and 251.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 1205579333, index ID 0, page (1:66796). Test (emptySlotCnt == 0) failed. Values are 1 and 0.
DBCC results for 'F_Terminal'.
There are 8 rows in 1 pages for object 'F_Terminal'.
DBCC results for 'F_Type'.
There are 7 rows in 1 pages for object 'F_Type'.
DBCC results for 'F_User'.
There are 1 rows in 1 pages for object 'F_User'.
DBCC results for 'F_GL_Reconcile'.
There are 2908 rows in 12 pages for object 'F_GL_Reconcile'.
DBCC results for 'F_Pm_La_Pay'.
There are 0 rows in 0 pages for object 'F_Pm_La_Pay'.
DBCC results for 'F_Pm_Property'.
There are 2293 rows in 121 pages for object 'F_Pm_Property'.
DBCC results for 'F_Cr_Entry'.
There are 3 rows in 1 pages for object 'F_Cr_Entry'.
DBCC results for 'F_Cr_Type'.
There are 0 rows in 0 pages for object 'F_Cr_Type'.
DBCC results for 'F_GL_Entry'.
There are 1190 rows in 11 pages for object 'F_GL_Entry'.
DBCC results for 'F_Pm_P_Analysis'.
There are 0 rows in 0 pages for object 'F_Pm_P_Analysis'.
DBCC results for 'F_Pm_Tenant'.
There are 4927 rows in 354 pages for object 'F_Pm_Tenant'.
DBCC results for 'F_Task'.
There are 847 rows in 17 pages for object 'F_Task'.
DBCC results for 'F_Item'.
There are 439788 rows in 5531 pages for object 'F_Item'.
DBCC results for 'F_Pm_Auto_Item'.
There are 2 rows in 1 pages for object 'F_Pm_Auto_Item'.
DBCC results for 'F_Pm_Diary'.
There are 5732 rows in 78 pages for object 'F_Pm_Diary'.
DBCC results for 'F_Pm_Entry'.
There are 671566 rows in 22181 pages for object 'F_Pm_Entry'.
CHECKDB found 0 allocation errors and 3 consistency errors in table 'F_Pm_Entry' (object ID 1205579333).
DBCC results for 'F_Pm_Job'.
There are 4169 rows in 128 pages for object 'F_Pm_Job'.
DBCC results for 'F_Pm_Job_Entry'.
There are 0 rows in 0 pages for object 'F_Pm_Job_Entry'.
DBCC results for 'F_Ftp_Listings'.
There are 0 rows in 0 pages for object 'F_Ftp_Listings'.
DBCC results for 'F_Ftp_System'.
There are 0 rows in 0 pages for object 'F_Ftp_System'.
DBCC results for 'F_RealEnz2'.
There are 0 rows in 0 pages for object 'F_RealEnz2'.
DBCC results for 'F_Security'.
There are 4 rows in 1 pages for object 'F_Security'.
DBCC results for 'F_Auto_Entry'.
There are 0 rows in 0 pages for object 'F_Auto_Entry'.
DBCC results for 'F_Au_Item'.
There are 0 rows in 0 pages for object 'F_Au_Item'.
DBCC results for 'F_Log'.
There are 0 rows in 0 pages for object 'F_Log'.
DBCC results for 'dtproperties'.
There are 0 rows in 0 pages for object 'dtproperties'.
DBCC results for 'F_Account'.
There are 229 rows in 3 pages for object 'F_Account'.
DBCC results for 'F_Analysis'.
There are 0 rows in 0 pages for object 'F_Analysis'.
DBCC results for 'F_Auto_Banking'.
There are 0 rows in 1 pages for object 'F_Auto_Banking'.
DBCC results for 'F_Branch'.
There are 3 rows in 1 pages for object 'F_Branch'.
DBCC results for 'F_Change'.
There are 5 rows in 1 pages for object 'F_Change'.
DBCC results for 'F_Clauses'.
There are 91 rows in 1 pages for object 'F_Clauses'.
CHECKDB found 0 allocation errors and 3 consistency errors in database 'rpm'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (db1 ).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
View 19 Replies
View Related
May 17, 2007
We had a bit of an accident last night.
My nightly maintenance task runs fine normally. Last night it didn't.
When it got to DBCC CHECKDB for an audit database (it gets populated from triggers in other databases; one of the tables has over a million records), the live database server shut down and did not come back up. DBCC CHECKDB completed in 6 seconds with no errors. The next task in the sequence that would have run (but the log has no message of it completing or failing) was DBCC INDEXDEFRAG on that audit table with over a million records.
Even the OFF button on the 64-bit Dell server (SQL2005, Windows Server Enterprise x64 2003 SP1, 16 gig ram) did not work. There wasn't even the blue screen of death. It was just a blue screen. A plug out and plug back in was required.
The only recent configuration change has been that we have had Dell install a piece of disk-level replication software called Double Take.
Could CheckDB have contributed to this problem?
View 20 Replies
View Related
Jul 16, 2007
When i run TKizers sp to check database integrity. I'm getting this error.
Executed as user: IAPESQLAdmin. ...536) DBCC results for 'sysobjects'. [SQLSTATE 01000] (Message 2536) There are 1364 rows in 23 pages for object 'sysobjects'. [SQLSTATE 01000] (Message 2593) DBCC results for 'sysindexes'. [SQLSTATE 01000] (Message 2536) There are 138 rows in 5 pages for object 'sysindexes'. [SQLSTATE 01000] (Message 2593) DBCC results for 'syscolumns'. [SQLSTATE 01000] (Message 2536) There are 5251 rows in 104 pages for object 'syscolumns'. [SQLSTATE 01000] (Message 2593) DBCC results for 'systypes'. [SQLSTATE 01000] (Message 2536) There are 26 rows in 1 pages for object 'systypes'. [SQLSTATE 01000] (Message 2593) DBCC results for 'syscomments'. [SQLSTATE 01000] (Message 2536) There are 2115 rows in 1112 pages for object 'syscomments'. [SQLSTATE 01000] (Message 2593) DBCC results for 'sysfiles1'. [SQLSTATE 01000] (Message 2536) There are 2 rows in 1 pages for object 'sysfiles1'. [SQLSTATE 01000] (Message 2593) DBCC results for 'syspermissions'. [SQLSTATE... The step failed.
=============================
http://www.sqlserverstudy.com
View 5 Replies
View Related
Aug 28, 2006
I ran "dbcc checkdb(MCMSdb) with no_infomsgs" and I get the following:Server: Msg 8946, Level 16, State 12, Line 2Table error: Allocation page (1:274992) has invalid PFS_PAGE pageheader values. Type is 0. Check type, object ID and page ID on thepage.What cane be done to correct this problem?Can this error prevent a user from connecting to the database?
View 2 Replies
View Related
Sep 8, 2000
My dbcc checkdb has been running for approximately 29 hours. Is this normal? Thanks!!!
View 6 Replies
View Related
Aug 30, 2002
Does anyone know how long DBCC CHECKDB REPAIR_REBUILD will take on a 4 GB database? The regular DBCC CHECKDB takes about 4 minutes.
Thanks
View 1 Replies
View Related
Sep 1, 2004
I need a bit of a hand with coding the DBCC CHECKDB command in QA.
I have been trying to configure my helpdesk database after moving drives in the original box after the old one ran out of space.
Now when i try and start the server daemons, i get a database check error.
can anyone help out with a DBCC CHECKDB command that will only check the database named AHDTEST50?
Thanks!
View 2 Replies
View Related
May 31, 2008
Hi,
Appreciated someone able to provide me some clu on how to perfom DBCC CHECKDB. Is it necessary to set the database to "Read only" before execute DBCC CHECKDB?
Appreaciated your help.
Regards,
Jimmy Liew
View 3 Replies
View Related
Jun 3, 2008
I have a database that was handed to me which is getting the following errors:
DBCC CHECKDB ('DBName') returns:
Server: Msg 8939, Level 16, State 106, Line 1
Table error: Object ID 1, index ID 0, page (1:37). Test (m_freeCnt == freeCnt) failed. Values are 680 and 788.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:37) with latch type SH. sysobjects failed.
DBCC PAGE (DBName, 1, 37, 1) returns:
Server: Msg 8939, Level 16, State 20, Line 1
Table error: Object ID 99, index ID 0, page (1:2). Test (m_slots[0].GetOffset () == PAGEHEADSIZE) failed. Values are 662 and 96.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 99, index ID 0, page (1:2). Test (Align(m_slots[-1].GetOffset ()) == Align(m_slots[0].GetOffset () + sizeof(GAMHEADER) + sizeof(DataRecHdr))) failed. Values are 190 and 756.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC PAGE (DBName, 1, 2, 1) returns:
Server: Msg 8939, Level 16, State 20, Line 1
Table error: Object ID 99, index ID 0, page (1:2). Test (m_slots[0].GetOffset () == PAGEHEADSIZE) failed. Values are 662 and 96.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 99, index ID 0, page (1:2). Test (Align(m_slots[-1].GetOffset ()) == Align(m_slots[0].GetOffset () + sizeof(GAMHEADER) + sizeof(DataRecHdr))) failed. Values are 190 and 756.
Server: Msg 3624, Level 20, State 1, Line 1
Location: recbase.cpp:1374
Expression: m_nVars > 0
SPID: 51
Process ID: 2096
Connection Broken
And finally, DBCC CHECKTABLE (sysobjects) WITH NO_INFOMSGS, ALL_ERRORMSGS gives me:
Server: Msg 8939, Level 16, State 106, Line 1
Table error: Object ID 1, index ID 0, page (1:37). Test (m_freeCnt == freeCnt) failed. Values are 680 and 788.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:37) with latch type SH. sysobjects failed.
I've looked at the MDF with a hex editor and there's definitely data in there. I have the DB attached and in single user/emergency mode, but DBCC isn't having much luck. Help?
View 9 Replies
View Related
Aug 4, 2005
Hi all, weird output ...
when running DBCC CHECKDB on a DB i get this error:
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (4:3457816) with latch type SH. sysindexes failed.
when running DBCC CHECKTABLE ('sysindexes') i get a little bit more info:
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (4:3457816) with latch type SH. sysindexes failed.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 2, index ID 0, page (4:3457816), row 9. Test (!(hdr->r_tagA & (VERSION_MASK | RECTAG_RESV_A | RECTAG_RESV_B))) failed. Values are 105 and 193.
CHECKTABLE found 0 allocation errors and 1 consistency errors in table 'sysindexes' (object ID 2).
I'm a bit clueless after seeing this and would like to know if someone has experienced this before and would be willing to offer some advice.
Thank you!
View 11 Replies
View Related
