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?
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
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
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.
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,
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]
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
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.
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?
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
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
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.
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?
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.
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?
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.
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?
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?
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.
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?
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?
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?
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'."
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
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.
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.
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.
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?
