CHECKDB Table Exclusion ?
Jun 8, 2006
Hi There
I have checked CHECKDB syntax in BOL, i just want to be sure.
In there no way to run CHECKDB on a user database and exclude certain tables, in SS2000.
I have 2 really huge tables , over a billion rows. Nightly i want to run CHECKDB on the database but i do NOT want CHECKTABLE run on these 2 tables as it takes hours.
Or is my only option to instead of running CHECKDB, writing a script that loops through user tables excluding these and running CHECKTABLE. If this is my only option can it be done with a cursor looping through user tables and running CHECKTABLE on each one?
Thanx
View 1 Replies
ADVERTISEMENT
Sep 11, 2015
below is some code I use to identify where a patient has attended the ED department whilst also admitted as an Inpatient. This report works fine. However while most of the results are recording issues to be corrected some of them are real and as so can be excluded from the report.
Is there a way I can build in an exclusion table which would include:
SELECT
IP_ADMISSION.HeyNo AS HEYNo
,IP_ADMISSION.NHSNo2 AS NHSNo
,IP_ADMISSION.Forename AS Forename
,IP_ADMISSION.Surname AS Surname
,IP_ADMISSION.SourceAdmNatCode AS SourceAdm
[code]....
View 4 Replies
View Related
May 22, 2006
I want to select all usernames from a table EXCEPT the "Admin" username...is this possible with an SQL statement and if so: how?
View 3 Replies
View Related
Dec 17, 2007
Hello,
I am trying to write a query that solves the following problem:
I want all records from [Table1] that are not referenced in [Table2].
Table2 has a foreign key that points back to the unique identifier of a record in Table1.
I'm not sure how to solve this type of query. I was looking into a left joins, but this is sort of the inverse of what I want to do.
Thank you for your help!
View 7 Replies
View Related
Jan 21, 2008
Hello,
I am facing an issue with a table in my database.
1) When I run a query Select * from MY_Table the query never completes. If I press cancel in Query Analyzer after 1 second or 2 minutes, it always shows the same 174 records. The total table size is 800 KB with 3148 rows .. according to TaskPad
2) No queries, even queries that would return only 1 record complete execution against that table
3) I am unable to rename the table, if I try to rename the table Enterprise Manager becomes unresponsive and has to be closed.
4) If I try to browse the rows through Enterprise manager by scrolling through the records, it allows me to go down through a number of rows and then Enterprise manager gives me a timeout expired error.
5) I ran a DBCC CheckDB command ran for 1 hr and 7 minutes. It says there are 0 allocation errors and 0 consistency errors in the database.
6) The other database tables seem to be OK and the Database is operational except for calls involving the 1 Table
7) I am unable to Drop the Table
8) DBCC CheckAlloc finds 0 allocation errors and 0 consistency errors.
9) DBCC CheckTable on MY_Table returns with: There are 3148 rows in 33 pages for object 'MY_Table' .. no errors are printed.
Can one of the SQL Gurus on this forum please recommend a course of action.
Thanks in advance.
View 1 Replies
View Related
May 20, 2008
I have two different views which I've linked together based on 3 different columns. Currently they're linked w/ an INNER JOIN.
What I need to do now, though, is figure out what records exist in one view and not the other. How is this done? I believe I did something like this before where I used an OUTER JOIN and then a "____ is NULL" condition in my WHERE clause, but I can't remember exactly what was going on.
Thanks!
View 3 Replies
View Related
Dec 21, 2006
Currently, I install an Anti-virus solution on MS SQL Server. It protects windows OS. In order to speed up the SQL performance, I dont want this Anti-virus to scan my SQL database. I want to know what's the exclusion list for the Anti-virus application. Thanks,
View 3 Replies
View Related
Jan 6, 2005
Hi
I have stupid users... who doesn't?! They have entered carriage returns as a whole value in some fields, that is, the field contains nothing more than a carriage return.
I really need to treat these cases as nulls and have successfully removed whole fields of nothing but spaces by using the LTRIM(RTRIM()) construct. Unfortunately, this doesn't deal with carraige returns. Even CASTing and CONVERTing to varchar and then using LTRIM(RTRIM()) doesn't work.
Does anyone know how I can elegantly get around this problem other than my best guess below:
Best guess pseudo code:
IF count of field is greater than 1 THEN probably a full sentence so ignore ELSE SUBSTRING first character and if CHAR(10, etc) then treat as NULL.
Here's some code that reconstructs the problem:
select datalength(char(13)) CarriageReturnVisible
, datalength(ltrim(rtrim(cast(char(13) as varchar)))) [This Don't Work]
Cheers - Andy
View 4 Replies
View Related
Sep 18, 2015
I am trying to import data from 4 columns in a spreadsheet, the Columns are (Last Name - First Name - ID - Code) and this spreadsheet has around 10k records. I want to add what is in this spreadsheet to the query I have below that uses the EXCEPT operator but I am not sure the best way to go about it.
Using the example I have filtered below for the name "Denise Test", at the end of the day I want everything that is in the spreadsheet to also be excluded from the results.
So before the spreadsheet lets say the 2nd query referencing table C has the following results for Denise Test
Last_Name First_Name ID Code
Test Denise 1 5
Test Denise 2 4
After adding the spreadsheet I want it to show this:
Last_Name First_Name ID Code
Test Denise 1 5
Test Denise 2 4
Test Denise 3 3
Here is the query as it stands now without the inclusion of the spreadsheet:
SELECT
ta.last_name,
ta.first_name,
tb.ID,
tb.code
FROM
TableA ta
INNER JOIN TableB tb
[code]....
View 0 Replies
View Related
Apr 14, 2008
I installed SQL Server 2005 Express Edition on my Laptop for use with IIS 7.0; Everything was working fine untill I opened the Report Server Site with WVD 2008, it asked me to Modify the web.config for debugging. After doing that the Report Server Site started showing an error page saying there was a rsInternal error. I tried fixing the Web.config by hand but it dident work, so I tried completly reinstalling the SQL Server 2005 Express Edition. It reinstalled perfectly excluding the Report Server. When it came time to install the Report Server; I got the error message.
The setup has encountered an unexpected error while Setting reporting service and share point exclusion path. The error is: Fatal error during installation.
--Actual Log--
Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Professional Service Pack 1 (Build 6001)
Time : Mon Apr 14 04:41:42 2008
Machine : JEOSYSTEMS-0002
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_JEOSYSTEMS-0002_SQLSupport_1.log
-----------------------------------------------------------------------------
Machine : JEOSYSTEMS-0002
Product : Microsoft Office 2003 Web Components
Product Version : 11.0.6558.0
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_JEOSYSTEMS-0002_OWC11_1.log
-----------------------------------------------------------------------------
Machine : JEOSYSTEMS-0002
Product : Microsoft SQL Server 2005 Backward compatibility
Product Version : 8.05.2004
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_JEOSYSTEMS-0002_BackwardsCompat_1.log
-----------------------------------------------------------------------------
Machine : JEOSYSTEMS-0002
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_JEOSYSTEMS-0002_SQLSupport_2.log
-----------------------------------------------------------------------------
Machine : JEOSYSTEMS-0002
Product : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_JEOSYSTEMS-0002_SQLNCLI_1.log
-----------------------------------------------------------------------------
Machine : JEOSYSTEMS-0002
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.3042.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_JEOSYSTEMS-0002_SqlWriter_1.log
-----------------------------------------------------------------------------
Machine : JEOSYSTEMS-0002
Product : Microsoft SQL Server 2005
Product Version : 9.2.3042.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_JEOSYSTEMS-0002_SQL.log
-----------------------------------------------------------------------------
Machine : JEOSYSTEMS-0002
Product : Reporting Services
Error : The setup has encountered an unexpected error while Setting reporting service and share point exclusion path. The error is: Fatal error during installation.
----------------------------------------------------------------------------
Machine : JEOSYSTEMS-0002
Product : Microsoft SQL Server 2005 Reporting Services
Product Version : 9.2.3042.00
Install : Failed
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_JEOSYSTEMS-0002_RS.log
Last Action : InstallFinalize
Error String : The setup has encountered an unexpected error while Setting reporting service and share point exclusion path. The error is: Fatal error during installation.
Error Number : 29528
-----------------------------------------------------------------------------
If anyone knows how to get Report Services to install after Error number 29528 occurs, Please let me know.
Thanks.
View 6 Replies
View Related
Oct 22, 2006
I got this error message during SQL Server Express install with no error code on Server 2003 SP1. I'm installing on an older development machine and although I do have a very large log file somewhere I wanted to post before I even dug into it. I noticed in IIS under my Webs that the MSSQLExpress webs were there at first but when I clicked on them to get any info or Properties... they dissapeared. So they were almost installed but they no longer exist. Also I do not have a SQL Service Manager icon down near the clock.
I almost took a step to fix this. After reading a few posts about similar problems I thought maybe this happened because the Default Web Sites IP # was not set to (All Unassigned). I was going to try a repair install from Add/Remove Programs but the temporary setup files are already gone. I really dont want to uninstall all 5 SQL components from Add/Remove Programs and start from scratch.
As good security practice we usually remove the Default Web or as in this development servers case we changed the IP from (All Unassigned) to an IP that is only accessible from certain machines on the internal network. I obviously should have read more pre setup guides. Anyway how can I fix this without reinstalling everything?
View 2 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
