InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 24 May 2012 12:36:56 GMT20http://www.sqlservercentral.com/Forums/Topic425130-265-1.aspxHi,I am in a very rough situation and would like some help/advise.My server crashed and I lost everything. Server was rebuilt and I tried to restore the .BAK file from tape. Noticed that backups were not going good as well. I found one .BAK file but when I restored it is reporting to be approx. 200Kb smaller than the size reported by windows. Backupexec restored 20785192 bytes but the size of the restored file is 20983171 bytes. Anyway, when I try to restore .BAK file from enterprise manager system just sits there for hours. and when I check the file it is reporting as corrupt/incomplete.Can anyone suggest any way to get data out of this file? It is a really bad situation. I will be calling MS tomorrow but any suggestions are welcome.Thu, 22 Nov 2007 22:23:56 GMTdpremihttp://www.sqlservercentral.com/Forums/Topic1282287-265-1.aspxHi all,Over the last few weeks 3 of our secondary (log-shipped) DB's have been marked 'Suspect', requiring drop+restore. I've been advised to check the I/O and try to faultfind.What practices/native tools exist for SS2K to get started on the investigation? BTW, if the initial diagnosis involves creating non-temp tables/objects, I would rather avoid this as even making slight changes involves having to raise an RFC.Also, would you recommend checking I/O on both Primary + Secondary servers?Thu, 12 Apr 2012 05:51:27 GMTjblovesthegymhttp://www.sqlservercentral.com/Forums/Topic1273153-265-1.aspxSorry Administrator (My Data is SQL Server 2005, I post in SQL Server 7,2000 :blush:)My Data Error After periodic check.Example:[quote]Table: NHAP—————ID | DateTime |—————1 | 20/2/2012|2 | 20/3/2012|Table: NHAPCT————-ID | SL | DG————-1 | 2 | 2001 | 2 | 5002 | 20 | 4003 | 30 | 700 <– This is Error[/quote]Pic:[img]http://i95.photobucket.com/albums/l137/thtuananh/MyDataError.gif[/img]My data has more than 70 tables and 50 FK. I want to test all FK. Which method. ThanksLink to download MyData:[url]http://www.mediafire.com/?z4azgwc2jwcx1om[/url]Mon, 26 Mar 2012 21:49:22 GMTtahatranhttp://www.sqlservercentral.com/Forums/Topic1132378-265-1.aspxRunning SQL Server 2000 standard 8.0.2055 (SP 4 +) on Windows 2003 standard. Server has low use to basically no use. Database has been growing since 2004, from about 10 MB to currently 292 MB (data 270 MB, log 23 MB), however data size has grown less than 10%. Recently have had two instances of data corruption (see dbcc errors below). My theory is that ghost rows are not being deleted and somehow that causes another bug which is the corruption. I'd like to know if my theory makes sense or not. The primary activity on the server is a copy program that copies 9 tables from a SQL 2008 database to the database in question using a delete all and then insert commands. Copy program runs every night.To resolve the problem I truncated the 9 tables and then re-ran the copy program. This reduced the data KB (per sp_spaceused) from 21296 KB to 2768 KB. Index size remained roughly the same.First instance of corruption produced errors like this in the FITB_EMPLOYEE table. I did not attempt to fix, I simply restored from the previous backup....[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 0, index ID 0, page ID (1:6719). The PageId in the page header = (0:0).[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 1442104178, index ID 2. Page (1:6480) is missing references from parent (unknown) and previous (page (0:0)) nodes. Possible bad root entry in sysindexes.[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Page (1:6481) allocated to object ID 1442104178, index ID 2 was not seen. Page may be invalid or have incorrect object ID information in its header....[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 5 consistency errors not associated with any single object.[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 64 consistency errors in table 'FITB_EMPLOYEE' (object ID 1442104178).[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 69 consistency errors in database 'DOFSHR'.[Microsoft][ODBC SQL Server Driver][SQL Server]repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (DOFSHR ).This is the entire report produced the second instance of data corruption. In this case, when we re-ran DBCC Checkdb, it found no errors. There may have been a rebuild index in between.[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 1442104178, index ID 2. Page (1:369) is missing references from parent (unknown) and previous (page (0:0)) nodes. Possible bad root entry in sysindexes.[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 1 consistency errors in table 'FITB_EMPLOYEE' (object ID 1442104178).[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 1 consistency errors in database 'DOFSHR'.[Microsoft][ODBC SQL Server Driver][SQL Server] repair_rebuild is the minimum repair level for the errors found by DBCC CHECKDB (DOFSHR ).Thank you in advance for you help and comments.lMon, 27 Jun 2011 12:42:43 GMTNicole Garrishttp://www.sqlservercentral.com/Forums/Topic1234254-265-1.aspxI was at least glad to find out what I am seeing in the error messages from a great article on this site:"Damaged allocation pagesMsg 8946, Level 16, State 12, Line 1 Table error: Allocation page (1:2264640) has invalid PFS_PAGE page header values. Type is 0. Check type, alloc unit ID and page ID on the page. Msg 8998, Level 16, State 2, Line 1 Page errors on the GAM, SGAM, or PFS pages prevent allocation integrity checks in database ID 13 pages from (1:2264640) to (1:2272727)In this case, one or more of the database allocation pages are damaged. The allocation pages are used to mark which pages and extents in the database are allocated and which are free. CheckDB will not repair damage to the allocation pages, as it is extremely difficult to work out, without those pages, what extents are allocated and which are not. Dropping the allocation page is not an option as that would discard up to 4GB of data."I guess the question I have is - where do I go from here? If I export the data and create a new database, can I import the data without importing the corruption? I have been working on this for 6 days now just to get the point I have the server back to between restoring the OS and backups and then working on trying to get the data to a recoverable state. I feel certain that I can get data via export/import but I don't want to do that until I know that corruption will not be included in this transaction. Here are the error messages I get on this database:Msg 8946, Level 16, State 12, Line 2Table error: Allocation page (1:40440) has invalid PFS_PAGE page header values. Type is 0. Check type, object ID and page ID on the page.DBCC results for 'accesscontrol'.Msg 8921, Level 16, State 1, Line 1CHECKTABLE terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.Msg 8998, Level 16, State 1, Line 1Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to verify database ID 5 pages from (1:40440) to (1:48527). See other errors for cause.CHECKDB found 1 allocation errors and 0 consistency errors not associated with any single object.Msg 8909, Level 16, State 1, Line 1Table error: Object ID 2133655552, index ID 32557, page ID (1:40440). The PageId in the page header = (0:13246).CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 2133655552)' (object ID 2133655552).CHECKDB found 1 allocation errors and 1 consistency errors in database 'AccessControl'.DBCC execution completed. If DBCC printed error messages, contact your system administrator.Any help is appreciated.Wed, 11 Jan 2012 11:52:01 GMTThomGhttp://www.sqlservercentral.com/Forums/Topic1211382-265-1.aspxHello.I'm currently trying to get a instance of sharepoint up and running after a server recovery. All the files have been restored including permissions. The MSSQL$SHAREPOINT service starts and then stops straight away. The error log looks like this2011-11-23 22:07:12.15 server Microsoft SQL Server 2000 - 8.00.2055 (Intel X86) Dec 16 2008 19:46:53 Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine (Windows) on Windows NT 5.2 (Build 3790: Service Pack 2)2011-11-23 22:07:12.16 server Copyright (C) 1988-2002 Microsoft Corporation.2011-11-23 22:07:12.18 server All rights reserved.2011-11-23 22:07:12.18 server Server Process ID is 7544.2011-11-23 22:07:12.18 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL$SHAREPOINT\LOG\ERRORLOG'.2011-11-23 22:07:12.21 server SQL Server is starting at priority class 'normal'(2 CPUs detected).2011-11-23 22:07:12.37 server SQL Server configured for thread mode processing.2011-11-23 22:07:12.37 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.2011-11-23 22:07:12.44 spid4 Starting up database 'master'.2011-11-23 22:07:12.57 spid4 1 transactions rolled back in database 'master' (1).2011-11-23 22:07:12.57 spid4 Recovery is checkpointing database 'master' (1)2011-11-23 22:07:12.69 server Using 'SSNETLIB.DLL' version '8.0.2039'.2011-11-23 22:07:12.69 spid5 Starting up database 'model'.2011-11-23 22:07:12.71 spid4 Server name is 'INTEGRITY\SHAREPOINT'.2011-11-23 22:07:12.74 spid8 Starting up database 'msdb'.2011-11-23 22:07:12.76 spid9 Starting up database 'STS_Config'.2011-11-23 22:07:12.76 server SQL server listening on Shared Memory.2011-11-23 22:07:12.76 server SQL Server is ready for client connections2011-11-23 22:07:12.76 spid10 Starting up database 'STS_INTEGRITY_1'.2011-11-23 22:07:12.98 spid8 1 transactions rolled back in database 'msdb' (4).2011-11-23 22:07:12.99 spid10 1 transactions rolled back in database 'STS_INTEGRITY_1' (6).2011-11-23 22:07:13.01 spid10 Recovery is checkpointing database 'STS_INTEGRITY_1' (6)2011-11-23 22:07:13.01 spid9 1 transactions rolled back in database 'STS_Config' (5).2011-11-23 22:07:13.02 spid5 1 transactions rolled back in database 'model' (3).2011-11-23 22:07:13.02 spid8 Recovery is checkpointing database 'msdb' (4)2011-11-23 22:07:13.02 spid5 Recovery is checkpointing database 'model' (3)2011-11-23 22:07:13.02 spid9 Recovery is checkpointing database 'STS_Config' (5)2011-11-23 22:07:13.34 spid5 Clearing tempdb database.2011-11-23 22:07:14.46 spid5 Starting up database 'tempdb'.2011-11-23 22:07:15.07 spid4 Recovery complete.2011-11-23 22:07:15.12 spid4 System database checksum file has invalid signature.I've searched around the internet and cant find any solution. I have tried restoring the files in C:\Program Files\Microsoft SQL Server\MSSQL$SHAREPOINT\Data with no luck. It is an SBS server and there are other databases running, so I don't want to restore the other folders as those DB's are starting and running. Any help or suggestions would be greatly appreciated!ThanksJames Wed, 23 Nov 2011 15:23:41 GMTj_allen_http://www.sqlservercentral.com/Forums/Topic563318-265-1.aspxI am using SQL Serer 2000 and want to know how to recover deleted records from a table / transaction log.Unfortunately one of my team member has accidentally deleted some records of an important table.Kindly suggest appropriate solution for the same.Wed, 03 Sep 2008 12:51:38 GMTarpankashyap-869238http://www.sqlservercentral.com/Forums/Topic1188226-265-1.aspx[b]In a SQL 2000, I have 2 stored procedures[/b]sproc1sproc2and using sp_helptext to see the SQL definition of that object[b]exec sp_helptext sproc1[/b]returns:...create procedure sproc1...[b]exec sp_helptext sproc2[/b]...create procedure sproc1 -- That is not a typo ....sproc1...[b]I also tried a query like:[/b]syscomments inner joined with sysobjects to return:syscomments.textsysobjects.nameThere are a few rows of syscomments.text...create procedure sproc1...[b]for both stored procedure object.[/b]yet when I [b]use SSMS & right-click modify[/b] / alter / drop and create...... procedure sproc1 or sproc2 -- depending where the right click was done...BTW-the same result happened in SQL 2008 (not R2) SQL Server.Let me please ask the questions:How could the right click (modify / alter / drop and create) be correct yet a query on the system tables or system stored procedures return in-correct?Does this mean that the system tables of the user database are corrupt?Is there a way to fix this? DBCC CheckDB?[b]Thank you for your time and any ideas to fix this system table corruption?[/b]Tue, 11 Oct 2011 00:51:51 GMTron_leghttp://www.sqlservercentral.com/Forums/Topic1173804-265-1.aspxI was approached today for a crashed SQL 2000 SP2 server with a single 800G database on it. Log is 20G. The database crashed due to the reason in the subject. I successfully recovered another backup from the same server, unfortunately it was long long time ago and size is only 3G, but structure is the same.I wonder how do I recover the rest of the data? Where should I start? I checked sysdatabases, I don't see the damaged database, not even in suspect mode.Any clue is greatly appreciated.Mon, 12 Sep 2011 15:21:59 GMThalifaxdalhttp://www.sqlservercentral.com/Forums/Topic1169992-265-1.aspxHi all,I am struggling with some databases going inconsistent.We are running SQL 2000 MSDE on NT 5.2. The db's (most of the times is only one of them but at times others join the party) generate the following error:[i]A possible database consistency problem has been detected on database 'xx'. DBCC CHECKDB and DBCC CHECKCATALOG should be run on database 'xx'.[/i]Obviously DBCC doesn't detect any errors. I checked the disks and the RAM but no errors there either. We have other server running 2005 and 2008 and they are fine so far.So now I am stuck with sql dumps which are generated every now and then. I have no idea what to do with them, the sql code that is 'dumped' is always different so I can't even match the failure with a specific action... And anyway I don't understand how some code can randomly make a db incosistent.Is there anything else I can do other than helplessly hand over the problem to MS ? (which I can't afford).I read in a post that a guy rebuild all his indexes and that saved the problem but it sounds like pure luck to me (rebuilding them maybe just moved them away from the bad sectors and he had io problems). I will try that too because i'm desperate.Thank you.Mon, 05 Sep 2011 09:01:29 GMTPavle-192195http://www.sqlservercentral.com/Forums/Topic1059822-265-1.aspxI have a table :CREATE TABLE [dbo].[haEmails] ( [emailRef] [int] IDENTITY (1, 1) NOT NULL , [Sent] [bit] NOT NULL , [FromUserNum] [int] NOT NULL , [ToUserNum] [int] NOT NULL , [MessageType] [int] NOT NULL , [AddedAt] [datetime] NOT NULL , [SentAt] [datetime] NULL , [MessageText] [varchar] (600) NULL , [Version20091013] [bit] NOT NULL ) ON [PRIMARY]GOALTER TABLE [dbo].[haEmails] WITH NOCHECK ADD CONSTRAINT [PK_TestEmails] PRIMARY KEY CLUSTERED ( [emailRef] ) WITH FILLFACTOR = 90 ON [PRIMARY] GOALTER TABLE [dbo].[haEmails] ADD CONSTRAINT [DF_TestEmails_Sent] DEFAULT (0) FOR [Sent], CONSTRAINT [DF_TestEmails_MessType] DEFAULT ((-1)) FOR [MessageType], CONSTRAINT [DF_TestEmails_AddedAt] DEFAULT (getdate()) FOR [AddedAt], CONSTRAINT [DF_haEmails_Version20091013] DEFAULT (0) FOR [Version20091013]GOMy application wasn't always responding to an INSERT trigger on the table, and my investigations found that :In Enterprise Manager, adding a new row : haEmails(FromUserNum,ToUserNum,MessageType) Values (22,11,-1)fails, with message "string or binary data would be truncated".But, Values (22,11,1) is successful.In the range 1..250 I only get this behaviour for FromUserNum = 22 or 74 or 97, all other FromUserNum integers allow a negative MessageType value.The criteria for failure appear to be : (FromUserNum = 22 OR FromUserNum = 74 OR FromUserNum = 97) AND MessageType < 0Can anyone tell me what's going on and how to avoid the problem ?Thanks in anticipation.Mike CMon, 07 Feb 2011 12:04:23 GMTmcinwghttp://www.sqlservercentral.com/Forums/Topic1130048-265-1.aspxHi allDoes anyone know what would cause data loss on tables after commit with no errors raised neither executed DELETEs? Is this a symptom of database corruption?I have seen this just twice from thousands records, using exactly the same Net Frmework code and Stored Procedure, suddenly there's no record in two tables that always must have data.There's no chance to avoid inserting in those tables.thanks for any advice.Wed, 22 Jun 2011 16:16:07 GMTNemachtianihttp://www.sqlservercentral.com/Forums/Topic1105944-265-1.aspxHi guys,Due to an unknown cause, some data in one table was deleted. There is no audit trail functionality for the application nor any timestamp field.The recovery model of the database is set to FULL but the data loss happened days before since the backup yesterday was already affected.Is there any measures that we can take to find the user that deleted the data?Like query the last users that logged-in to the server and accessed the database? or get the all the DML statements that were executed to the database? or any related diagnostic measures.Thank you.Tue, 10 May 2011 03:05:30 GMTricharddelcarmenhttp://www.sqlservercentral.com/Forums/Topic1108597-265-1.aspxWe have a distribution database on a dedicated distributor server which went into suspect mode. The reason we believe to be that the log file size was limited to 2Gigs when we upgraded it from 2000 to 2008. The upgrade process worked fine and we've been using the server successfully ever since until this morning. The size of the LOG file is 24Gigs despite the size limitation and that is probably because it was like that at the moment when the upgrade was done. Due to some increasingly replication activity probably the db tried to increase the log file even more but failed due to the limitation and started to through errors. At that point we restarted the server but it shows suspect mode after finishes the restart.We have a backup until the problem started this morning.What are the options?Thank you.Fri, 13 May 2011 10:02:18 GMTthe sqlisthttp://www.sqlservercentral.com/Forums/Topic522478-265-1.aspxHi,When I tried attaching the AdventureWorks Database to the SQL 2005 I get the following error.Msg 1813, Level 16, State 2, Line 1Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.Msg 602, Level 21, State 50, Line 1Could not find row in sysindexes for database ID 8, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.Could you please let me know how can I attach the AdventureWorks Database.Tue, 24 Jun 2008 06:11:58 GMTnisha.lakhwarahttp://www.sqlservercentral.com/Forums/Topic1088772-265-1.aspxnot speak english ,,, goodHi AllI Have Sql Server 2000 databasename : Horizonand if i want to update some tables show this messege :" Database Error|Integrty trigger failedid#s are maintained by triggers and cannot be updated otherwise"how do to solve this proble;firs time show this messege, i use this database since 4 years until nowThankYou;Tue, 05 Apr 2011 10:58:22 GMTambo.phphttp://www.sqlservercentral.com/Forums/Topic1083065-265-1.aspxSQL 2000 Enterprise SP4.Our SQL server is periodically getting 823 errors as follows: Error: 823, Severity: 24, State: 2I/O error (bad page ID) detected during read at offset 0x00000022018000 in file 'F:\SQLDataFiles\Click2Coach_Data.MDF'. If I run DBCC CHECKDB sometimes it returns errors and sometimes it doesn't. Today I ran DBCC CHECKDB with repair and it reported about 12 errors fixed. However, the 823s started up again shortly after the repair finished. I've been running the DBCC CHECKDB statement periodically throughout the day. Most times it's clean but other times it returns errors. I took one of the object IDs that were in the error message and couldn't find it in sysobjects. We have run diagnostics on the disk and haven't found any problems. We also detached and moved the DB to a different drive (although it was just a logical drive), but that seemed to have no effect. Any ideas?Wed, 23 Mar 2011 18:42:51 GMTChristopher Westhttp://www.sqlservercentral.com/Forums/Topic1063342-265-1.aspxI coulnd not backup the database in sql server 2000 . i got erro" Nonreoverable I/O error occured 'E:\mssql\data.mdf' . this is haraware related error. disk problem.. Please help me .How to recover the backup data..Mon, 14 Feb 2011 01:12:29 GMTsolomon.jernashttp://www.sqlservercentral.com/Forums/Topic1056204-265-1.aspxSQL Server 2000.... How do I find what tables these problem objects are?[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Table '(Object ID 324208951)' (ID 324208951). Missing or invalid key in index '(Index ID 5)' (ID 5) for the row:[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Table '(Object ID 324208951)' (ID 324208951). Missing or invalid key in index '(Index ID 5)' (ID 5) for the row:[Microsoft][ODBC SQL Server Driver][SQL Server]Data row (1:2569152:49) identified by (RID = (1:2569152:49) ) has index values (DMA_NBR = 678 and FRANID = '102800').[Microsoft][ODBC SQL Server Driver][SQL Server]Data row (1:2569152:69) identified by (RID = (1:2569152:69) ) has index values (DMA_NBR = 679 and FRANID = '105800').[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Table '(Object ID 324208951)' (ID 324208951). Missing or invalid key in index '(Index ID 5)' (ID 5) for the row:[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 36 consistency errors in database 'AFA_MKIS'.[Microsoft][ODBC SQL Server Driver][SQL Server]repair_fast is the minimum repair level for the errors found by DBCC CHECKDB (AFA_MKIS ).Mon, 31 Jan 2011 07:50:55 GMTMarkushttp://www.sqlservercentral.com/Forums/Topic1051070-265-1.aspxA SQL Server 200 database went down. It was backed up on tape, but I don't think it was a proper .bak backup, I think it was just a backup of the .mdb. (I don't have access to these things on this server). It is currently being restored. SQL Server lists the database as (Restoring...)What kind of problems should I look out for in this situation? Will the restoration simply fail if it isn't from a .bak?Thu, 20 Jan 2011 11:41:49 GMTStefan Krzywickihttp://www.sqlservercentral.com/Forums/Topic1043043-265-1.aspxWe have corruption on one of our Sharepoint databases (SQL Server 2000). We've run a DBCC REPAIR_ALLOW_DATA_LOSS on a test server and the output is below (dir names and leaf names removed):[b]Nonqualified transactions are being rolled back. Estimated rollback completion: 100%.DBCC results for '<dbname>'.DBCC results for 'sysobjects'.There are 529 rows in 11 pages for object 'sysobjects'.DBCC results for 'sysindexes'.There are 188 rows in 8 pages for object 'sysindexes'.DBCC results for 'syscolumns'.There are 3516 rows in 54 pages for object 'syscolumns'.DBCC results for 'systypes'.There are 28 rows in 1 pages for object 'systypes'.DBCC results for 'syscomments'.There are 698 rows in 206 pages for object 'syscomments'.DBCC results for 'sysfiles1'.There are 2 rows in 1 pages for object 'sysfiles1'.DBCC results for 'syspermissions'.There are 18 rows in 1 pages for object 'syspermissions'.DBCC results for 'sysusers'.There are 13 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 6143 rows in 32 pages for object 'sysdepends'.DBCC results for 'sysreferences'.There are 1 rows in 1 pages for object 'sysreferences'.DBCC results for 'sysfulltextcatalogs'.There are 0 rows in 1 pages for object 'sysfulltextcatalogs'.DBCC results for 'sysfulltextnotify'.There are 0 rows in 1 pages for object 'sysfulltextnotify'.DBCC results for 'sysfilegroups'.There are 1 rows in 1 pages for object 'sysfilegroups'.Server: Msg 8929, Level 16, State 1, Line 1Object ID 1993058136: Errors found in text ID 301518225408 owned by data record identified by RID = (1:1673852:13) SiteId = D7187BC0-42A8-471F-B5A0-E34808CAFF6F and DirName = '<dirname>' and LeafName = '<leafname>'.Server: Msg 8929, Level 16, State 1, Line 1Object ID 1993058136: Errors found in text ID 301518290944 owned by data record identified by RID = (1:1673852:13) SiteId = D7187BC0-42A8-471F-B5A0-E34808CAFF6F and DirName = '<dirname>' and LeafName = '<leafname>'.Server: Msg 8929, Level 16, State 1, Line 1Object ID 1993058136: Errors found in text ID 301518356480 owned by data record identified by RID = (1:1673852:13) SiteId = D7187BC0-42A8-471F-B5A0-E34808CAFF6F and DirName = '<dirname>' and LeafName = '<leafname>'.Server: Msg 8929, Level 16, State 1, Line 1Object ID 1993058136: Errors found in text ID 301507018752 owned by data record identified by RID = (1:4455912:15) SiteId = A8380FDC-921C-438D-A184-67EC05B7140B and DirName = '<dirname>' and LeafName = '<leafname>Server: Msg 8929, Level 16, State 1, Line 1Object ID 1993058136: Errors found in text ID 120336154624 owned by data record identified by RID = (1:7785459:9) SiteId = FA32B7C4-C2C3-43D5-8D29-C5224EC2DC3F and DirName = '<dirname>' and LeafName = '<leafname>Server: Msg 8929, Level 16, State 1, Line 1Object ID 1993058136: Errors found in text ID 314912276480 owned by data record identified by RID = (1:7790766:7) SiteId = 7BA0E748-6B6D-41EE-A80C-233A94614F6A and DirName = '<dirname>' and LeafName = '<leafname>'.Server: Msg 8929, Level 16, State 1, Line 1Object ID 1993058136: Errors found in text ID 314912342016 owned by data record identified by RID = (1:7790766:7) SiteId = 7BA0E748-6B6D-41EE-A80C-233A94614F6A and DirName = '<dirname>' and LeafName = '<leafname>'.Server: Msg 8929, Level 16, State 1, Line 1Object ID 1993058136: Errors found in text ID 314909982720 owned by data record identified by RID = (1:7790766:8) SiteId = 7BA0E748-6B6D-41EE-A80C-233A94614F6A and DirName = '<dirname>' and LeafName = '<leafname>'.Server: Msg 8929, Level 16, State 1, Line 1Object ID 1993058136: Errors found in text ID 314910048256 owned by data record identified by RID = (1:7790766:8) SiteId = 7BA0E748-6B6D-41EE-A80C-233A94614F6A and DirName = '<dirname>' and LeafName = '<leafname>'.Server: Msg 8929, Level 16, State 1, Line 1Object ID 1993058136: Errors found in text ID 314910113792 owned by data record identified by RID = (1:7790766:8) SiteId = 7BA0E748-6B6D-41EE-A80C-233A94614F6A and DirName = '<dirname>' and LeafName = '<leafname>'.Server: Msg 8929, Level 16, State 1, Line 1Object ID 1993058136: Errors found in text ID 301509378048 owned by data record identified by RID = (1:8331567:8) SiteId = 40B075ED-CD17-47DF-93E6-EDE8626DE96C and DirName = '<dirname>' and LeafName = '<leafname>'.Server: Msg 8929, Level 16, State 1, Line 1Object ID 1993058136: Errors found in text ID 314907688960 owned by data record identified by RID = (1:8470263:17) SiteId = 726A74F2-A51F-425A-8404-93A0DF59C5B1 and DirName = '<dirname>' and LeafName = '<leafname>'.Server: Msg 8929, Level 16, State 1, Line 1Object ID 1993058136: Errors found in text ID 314907754496 owned by data record identified by RID = (1:8470263:17) SiteId = 726A74F2-A51F-425A-8404-93A0DF59C5B1 and DirName = '<dirname>' and LeafName = '<leafname>'.DBCC results for 'Sites'.There are 516 rows in 31 pages for object 'Sites'.DBCC results for 'Webs'.There are 516 rows in 430 pages for object 'Webs'.DBCC results for 'Categories'.There are 0 rows in 0 pages for object 'Categories'.DBCC results for 'WebCat'.There are 6192 rows in 96 pages for object 'WebCat'.DBCC results for 'Lists'.There are 5147 rows in 623 pages for object 'Lists'.DBCC results for 'UserData'.There are 823247 rows in 138691 pages for object 'UserData'.DBCC results for 'WebParts'.There are 28314 rows in 996 pages for object 'WebParts'.DBCC results for 'EventCache'.There are 0 rows in 0 pages for object 'EventCache'.DBCC results for 'EventLog'.There are 0 rows in 0 pages for object 'EventLog'.DBCC results for 'ImmedSubscriptions'.There are 0 rows in 0 pages for object 'ImmedSubscriptions'.DBCC results for 'SchedSubscriptions'.There are 0 rows in 0 pages for object 'SchedSubscriptions'.DBCC results for 'Personalization'.There are 0 rows in 0 pages for object 'Personalization'.DBCC results for 'WelcomeNames'.There are 2 rows in 1 pages for object 'WelcomeNames'.DBCC results for 'TimerLock'.There are 1 rows in 1 pages for object 'TimerLock'.DBCC results for 'DiskWarningDate'.There are 1 rows in 1 pages for object 'DiskWarningDate'.DBCC results for 'ComMd'.There are 42 rows in 1 pages for object 'ComMd'.DBCC results for 'UserInfo'.There are 17858 rows in 610 pages for object 'UserInfo'.DBCC results for 'dtproperties'.There are 0 rows in 0 pages for object 'dtproperties'.DBCC results for 'WebMembers'.There are 16872 rows in 165 pages for object 'WebMembers'.DBCC results for 'SiteGroupMembership'.There are 0 rows in 0 pages for object 'SiteGroupMembership'.DBCC results for 'WebGroupMembership'.There are 12421 rows in 90 pages for object 'WebGroupMembership'.DBCC results for 'WebGroups'.There are 2580 rows in 125 pages for object 'WebGroups'.DBCC results for 'SiteGroups'.There are 0 rows in 0 pages for object 'SiteGroups'.DBCC results for 'SystemVersion'.There are 1 rows in 1 pages for object 'SystemVersion'.DBCC results for 'HT_Settings'.There are 5 rows in 1 pages for object 'HT_Settings'.DBCC results for 'HT_Cache'.There are 0 rows in 0 pages for object 'HT_Cache'.DBCC results for 'Deps'.There are 69 rows in 4 pages for object 'Deps'.DBCC results for 'Docs'. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired.Server: Msg 8929, Level 16, State 1, Line 1Object ID 1993058136: Errors found in text ID 314907820032 owned by data record identified by RID = (1:8470263:17) SiteId = 726A74F2-A51F-425A-8404-93A0DF59C5B1 and DirName = '<dirname>' and LeafName = '<leafname>'.Server: Msg 8929, Level 16, State 1, Line 1Object ID 1993058136: Errors found in text ID 312662818816 owned by data record identified by RID = (1:9907830:14) SiteId = 6104BB99-1030-4C9C-9285-958C88B8C25C and DirName = '<dirname>' and LeafName = '<leafname>'.Server: Msg 8929, Level 16, State 1, Line 1Object ID 1993058136: Errors found in text ID 312662884352 owned by data record identified by RID = (1:9907830:14) SiteId = 6104BB99-1030-4C9C-9285-958C88B8C25C and DirName = '<dirname>' and LeafName = '<leafname>'.Server: Msg 8929, Level 16, State 1, Line 1Object ID 1993058136: Errors found in text ID 301568819200 owned by data record identified by RID = (1:10138160:1) SiteId = 6104BB99-1030-4C9C-9285-958C88B8C25C and DirName = '<dirname>' and LeafName = '<leafname>Server: Msg 8929, Level 16, State 1, Line 1Object ID 1993058136: Errors found in text ID 301568884736 owned by data record identified by RID = (1:10138160:1) SiteId = 6104BB99-1030-4C9C-9285-958C88B8C25C and DirName = '<dirname>' and LeafName = '<leafname>Server: Msg 8929, Level 16, State 1, Line 1Object ID 1993058136: Errors found in text ID 315290615808 owned by data record identified by RID = (1:11937877:1) SiteId = 508120F8-4CFD-4B68-A046-BFEB1C59B123 and DirName = '<dirname>' and LeafName = '<leafname>'.Server: Msg 8929, Level 16, State 1, Line 1Object ID 1993058136: Errors found in text ID 315290681344 owned by data record identified by RID = (1:11937877:1) SiteId = 508120F8-4CFD-4B68-A046-BFEB1C59B123 and DirName = '<dirname>' and LeafName = '<leafname>'.Server: Msg 8929, Level 16, State 1, Line 1Object ID 1993058136: Errors found in text ID 315292909568 owned by data record identified by RID = (1:11946282:10) SiteId = 508120F8-4CFD-4B68-A046-BFEB1C59B123 and DirName = '<dirname>' and LeafName = '<leafname>'.Server: Msg 8929, Level 16, State 1, Line 1Object ID 1993058136: Errors found in text ID 315292975104 owned by data record identified by RID = (1:11946282:10) SiteId = 508120F8-4CFD-4B68-A046-BFEB1C59B123 and DirName = '<dirname>' and LeafName = '<leafname>'.Server: Msg 8929, Level 16, State 1, Line 1Object ID 1993058136: Errors found in text ID 315293040640 owned by data record identified by RID = (1:11946282:10) SiteId = 508120F8-4CFD-4B68-A046-BFEB1C59B123 and DirName = '<dirname>' and LeafName = '<leafname>'.Server: Msg 8929, Level 16, State 1, Line 1Object ID 1993058136: Errors found in text ID 301522944000 owned by data record identified by RID = (1:17738338:7) SiteId = 6104BB99-1030-4C9C-9285-958C88B8C25C and DirName = '<dirname>' and LeafName = '<leafname>'.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9191128), slot 2, text ID 312662818816 is not referenced.Server: Msg 8928, Level 16, State 1, Line 1Object ID 1993058136, index ID 255: Page (1:9583792) could not be processed. See other errors for details.Server: Msg 8965, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 1, text ID 301507018752 is referenced by page (1:4455912), slot 15, but was not seen in the scan.Server: Msg 8965, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 2, text ID 301509378048 is referenced by page (1:8331567), slot 8, but was not seen in the scan.Server: Msg 8944, Level 16, State 1, Line 1Table error: Object ID 1993058136, index ID 255, page (1:9583792), row 3. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 65280 and 1121.Server: Msg 8965, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 4, text ID 301518225408 is referenced by page (1:1673852), slot 13, but was not seen in the scan.Server: Msg 8965, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 5, text ID 301518290944 is referenced by page (1:1673852), slot 13, but was not seen in the scan.Server: Msg 8965, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 6, text ID 301518356480 is referenced by page (1:1673852), slot 13, but was not seen in the scan.Server: Msg 8965, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 7, text ID 301522944000 is referenced by page (1:17738338), slot 7, but was not seen in the scan.Server: Msg 8965, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 8, text ID 301568819200 is referenced by page (1:10138160), slot 1, but was not seen in the scan.Server: Msg 8965, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 9, text ID 301568884736 is referenced by page (1:10138160), slot 1, but was not seen in the scan.Server: Msg 8965, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 16, text ID 312662818816 is referenced by page (1:9907830), slot 14, but was not seen in the scan.Server: Msg 8965, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 17, text ID 312662884352 is referenced by page (1:9907830), slot 14, but was not seen in the scan.Server: Msg 8965, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 19, text ID 314907688960 is referenced by page (1:8470263), slot 17, but was not seen in the scan.Server: Msg 8965, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 20, text ID 314907754496 is referenced by page (1:8470263), slot 17, but was not seen in the scan.Server: Msg 8965, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 21, text ID 314907820032 is referenced by page (1:8470263), slot 17, but was not seen in the scan.Server: Msg 8965, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 22, text ID 314909982720 is referenced by page (1:7790766), slot 8, but was not seen in the scan. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired.Server: Msg 8965, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 23, text ID 314910048256 is referenced by page (1:7790766), slot 8, but was not seen in the scan.Server: Msg 8965, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 24, text ID 314910113792 is referenced by page (1:7790766), slot 8, but was not seen in the scan.Server: Msg 8965, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 25, text ID 314912276480 is referenced by page (1:7790766), slot 7, but was not seen in the scan.Server: Msg 8965, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 26, text ID 314912342016 is referenced by page (1:7790766), slot 7, but was not seen in the scan.Server: Msg 8965, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 27, text ID 315290615808 is referenced by page (1:11937877), slot 1, but was not seen in the scan.Server: Msg 8965, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 28, text ID 315290681344 is referenced by page (1:11937877), slot 1, but was not seen in the scan.Server: Msg 8965, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 30, text ID 315292909568 is referenced by page (1:11946282), slot 10, but was not seen in the scan.Server: Msg 8965, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 31, text ID 315292975104 is referenced by page (1:11946282), slot 10, but was not seen in the scan.Server: Msg 8965, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9583792), slot 32, text ID 315293040640 is referenced by page (1:11946282), slot 10, but was not seen in the scan.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9871194), slot 0, text ID 301507018752 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:9871455), slot 0, text ID 301568884736 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:10088545), slot 0, text ID 312662884352 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:10088546), slot 0, text ID 312662884352 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:10088547), slot 0, text ID 312662884352 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:10088548), slot 0, text ID 312662884352 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:10153036), slot 1, text ID 314909982720 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:10153036), slot 2, text ID 314912276480 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:10153331), slot 0, text ID 314907754496 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:10153332), slot 0, text ID 314910048256 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:10153333), slot 0, text ID 314910048256 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:10153334), slot 0, text ID 314910048256 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:10153335), slot 0, text ID 314910048256 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:10159975), slot 0, text ID 315290681344 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:10159979), slot 0, text ID 315292975104 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:10159980), slot 0, text ID 315292975104 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:10159981), slot 0, text ID 315292975104 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:10159982), slot 0, text ID 315292975104 is not referenced.Server: Msg 8928, Level 16, State 1, Line 1Object ID 1993058136, index ID 255: Page (1:10542555) could not be processed. See other errors for details.Server: Msg 8939, Level 16, State 1, Line 1Table error: Object ID 1993058136, index ID 255, page (1:10542555). Test (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.Server: Msg 8965, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:10542555), slot 0, text ID 120336154624 is referenced by page (1:10542531), slot 0, but was not seen in the scan.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:11926382), slot 15, text ID 315292975104 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:13640409), slot 0, text ID 314910048256 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:13640410), slot 0, text ID 314912342016 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 1993058136. The text, ntext, or image node at page (1:19888540), slot 0, text ID 301518290944 is not referenced. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired.Repair: Deleted text column, text ID 301518225408, for object ID 1993058136 on page (1:1673852), slot 13.Repair: Deleted text column, text ID 301518290944, for object ID 1993058136 on page (1:1673852), slot 13.Repair: Deleted text column, text ID 301518356480, for object ID 1993058136 on page (1:1673852), slot 13.Server: Msg 8952, Level 16, State 1, Line 1Table error: Database '<dbname>', index 'Links.Links_Backward' (ID 2121058592) (index ID 2). Extra or invalid key for the keys:Server: Msg 8956, Level 16, State 1, Line 1Index row (1:22736431:4) with values (SiteId = 5515C06E-0231-4A19-8BF9-885CE79178A9 and TargetDirName = '<dirname>' and TargetLeafName = NULL and SiteId = 5515C06E-0231-4A19-8BF9-885CE79178A9 and DirName = 'pe) points to the data row identified by ().Server: Msg 8952, Level 16, State 1, Line 1Table error: Database '<dbname>', index 'Links.Links_Backward' (ID 2121058592) (index ID 2). Extra or invalid key for the keys:Server: Msg 8956, Level 16, State 1, Line 1Index row (1:22736431:9) with values (SiteId = 5515C06E-0231-4A19-8BF9-885CE79178A9 and TargetDirName = '<dirname>' and TargetLeafName = NULL and SiteId = 5515C06E-0231-4A19-8BF9-885CE79178A9 and DirName = '<dirname>' and LeafName = '<leafname>) points to the data row identified by ().Repair: Deleted text column, text ID 301507018752, for object ID 1993058136 on page (1:4455912), slot 15.Repair: Deleted text column, text ID 120336154624, for object ID 1993058136 on page (1:7785459), slot 9.Repair: Deleted text column, text ID 314912276480, for object ID 1993058136 on page (1:7790766), slot 7.Repair: Deleted text column, text ID 314912342016, for object ID 1993058136 on page (1:7790766), slot 7.Repair: Deleted text column, text ID 314909982720, for object ID 1993058136 on page (1:7790766), slot 8.Repair: Deleted text column, text ID 314910048256, for object ID 1993058136 on page (1:7790766), slot 8.Repair: Deleted text column, text ID 314910113792, for object ID 1993058136 on page (1:7790766), slot 8.Repair: Deleted text column, text ID 301509378048, for object ID 1993058136 on page (1:8331567), slot 8.Repair: Deleted text column, text ID 314907688960, for object ID 1993058136 on page (1:8470263), slot 17.Repair: Deleted text column, text ID 314907754496, for object ID 1993058136 on page (1:8470263), slot 17.Repair: Deleted text column, text ID 314907820032, for object ID 1993058136 on page (1:8470263), slot 17.Repair: Deleted text column, text ID 312662818816, for object ID 1993058136 on page (1:9907830), slot 14.Repair: Deleted text column, text ID 312662884352, for object ID 1993058136 on page (1:9907830), slot 14.Repair: Deleted text column, text ID 301568819200, for object ID 1993058136 on page (1:10138160), slot 1.Repair: Deleted text column, text ID 301568884736, for object ID 1993058136 on page (1:10138160), slot 1.Repair: Deleted text column, text ID 315290615808, for object ID 1993058136 on page (1:11937877), slot 1.Repair: Deleted text column, text ID 315290681344, for object ID 1993058136 on page (1:11937877), slot 1.Repair: Deleted text column, text ID 315292909568, for object ID 1993058136 on page (1:11946282), slot 10.Repair: Deleted text column, text ID 315292975104, for object ID 1993058136 on page (1:11946282), slot 10.Repair: Deleted text column, text ID 315293040640, for object ID 1993058136 on page (1:11946282), slot 10.Repair: Deleted text column, text ID 301522944000, for object ID 1993058136 on page (1:17738338), slot 7.Repair: Page (1:9583792) has been deallocated from object ID 1993058136, index ID 255.Repair: Page (1:10542555) has been deallocated from object ID 1993058136, index ID 255.There are 868438 rows in 78804 pages for object 'Docs'.CHECKDB found 0 allocation errors and 75 consistency errors in table 'Docs' (object ID 1993058136).CHECKDB fixed 0 allocation errors and 75 consistency errors in table 'Docs' (object ID 1993058136).DBCC results for 'DocVersions'.There are 4689 rows in 122 pages for object 'DocVersions'.DBCC results for 'Links'. The error has been repaired. The error has been repaired.There are 179168 rows in 11717 pages for object 'Links'.CHECKDB found 0 allocation errors and 2 consistency errors in table 'Links' (object ID 2121058592).CHECKDB fixed 0 allocation errors and 2 consistency errors in table 'Links' (object ID 2121058592).DBCC results for 'NavNodes'.There are 7064 rows in 240 pages for object 'NavNodes'.CHECKDB found 0 allocation errors and 77 consistency errors in database '<dbname>'.CHECKDB fixed 0 allocation errors and 77 consistency errors in database '<dbname>'.DBCC execution completed. If DBCC printed error messages, contact your system administrator.[/b]It is encouraging that all errors have been fixed, but is there any way to determine exactly which data loss has occurred following the repair?Also, we've seen various suggestions that DBCC REPAIR_ALLOW_DATA_LOSS should not be run on a SharePoint database, including here: http://support.microsoft.com/kb/841057/en-us , so we're currently debating whether this is even an option for us.Thanks very muchPGWed, 05 Jan 2011 07:14:30 GMTPhineas Gagehttp://www.sqlservercentral.com/Forums/Topic1005710-265-1.aspxDear friends ,I was wondering about this situation.After some search i have find out that many people has this problem.worst one has a Db about 6 Tera Byte and...Do you know why this kind of errors happening?I mean Why SQLServer makes pages with errors like this?For example :Page (1:1000698) in database ID 65 is allocated in the SGAM (1:511233) and PFS (1:994824), but was not allocated in any IAM.Sat, 16 Oct 2010 06:35:58 GMTashkan sirooshttp://www.sqlservercentral.com/Forums/Topic964481-265-1.aspxHi all.We have a SQL 2000 database that is causing a few headaches. Its up to SP4 and running on an active/passive cluster on Windows 2003. The users access the database via an MS Access 2000 frontend that uses SP's to perform all insert/update/delete actions.Every few weeks an index will get corrupted. As yet we have no idea why. The server isn't under any particular strain (CPU 40% max, 1.6Gb free RAM). The database is approx 13Gb in size and is replicated to another database on the same server. There are approx 500 concurrent users who only access main database not the replicated one.Most of the time the corruption occurs on the largest table (2Gb) but has sometimes occured on the replicated copy of that table and not on the main copy.We set the index rebuild to run each night and since then (3 months) it hasn't happenned since, but I'd like to get an idea on the possible causes.The event log only shows the below error:[sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][ODBC SQL Server Driver]Communication link failure Event id 17052 [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed SuperSocket info: (SpnRegister) : Error 8344. [sqsrvres] OnlineThread: service stopped while waiting for QP.The users all connect through the same 8mb connection which at times gets maxed out. Could this potentially cause this issue?I'm looking for ideas/pointers as for where to look or for articles on the web that may help.Thu, 05 Aug 2010 10:44:44 GMTdavid.r.nicholsonhttp://www.sqlservercentral.com/Forums/Topic1005752-265-1.aspxDear friends,My data base has corrupted and I need help.:([b]I have execute: DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS and it returned 3000 line of error and this lines on the end:[/b]Server: Msg 8948, Level 16, State 1, Line 1Database error: Page (1:7335) is marked with the wrong type in PFS page (1:1). PFS status 0x70 expected 0x60.Server: Msg 8966, Level 16, State 1, Line 1Could not read and latch page (1:7335) with latch type SH. VerifyPageId failed.[b]CHECKDB found 1563 allocation errors and 0 consistency errors not associated with any single object.CHECKDB found 1563 allocation errors and 0 consistency errors in database 'FAQ'.[/b]repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (FAQ ).[b]Then I used this commands:[/b]ALTER DATABASE FAQSET single_user WITH ROLLBACK IMMEDIATE;goDBCC checkdb ('FAQ', repair_allow_data_loss);goit returned 500 line of report (some errors and some repaired text) with this line at the end;CHECKDB found 1000 allocation errors and 0 consistency errors in database 'FAQ'.CHECKDB fixed 500 allocation errors and 0 consistency errors in database 'FAQ'.repair_fast is the minimum repair level for the errors found by DBCC CHECKDB (FAQ repair_allow_data_loss).DBCC execution completed. If DBCC printed error messages, contact your system administrator.[b]then i used :ALTER DATABASE FAQ[/b]SET single_user WITH ROLLBACK IMMEDIATE;goDBCC checkdb ('FAQ',repair_fast );go[b]and it returned 500 line of report (some errors and some repaired text) with this line at the end(like before);[/b]CHECKDB found 1000 allocation errors and 0 consistency errors in database 'FAQ'.repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (FAQ repair_fast).DBCC execution completed. If DBCC printed error messages, contact your system administrator.[b]and the loop is continued.what should i do now??!!?!? [Sad][/b]Sat, 16 Oct 2010 08:51:41 GMTashkan sirooshttp://www.sqlservercentral.com/Forums/Topic996756-265-1.aspxICBM came up in suspect Errorlog reported a torn page.USE mastergoupdate sysdatabases set status=32768 where name='ICBM'restart SQL serverdbcc checkdb('ICBM', NOINDEX) with all_errormsgs, no_infomsgsServer: Msg 2515, Level 16, State 1, Line 7Page (1:16881268), object ID 751341741, index ID 0 has been modified but is not marked modified in the differential backup bitmap.Server: Msg 8928, Level 16, State 1, Line 7Object ID 751341741, index ID 0: Page (1:18360105) could not be processed. See other errors for details.Server: Msg 8939, Level 16, State 1, Line 7Table error: Object ID 751341741, index ID 0, page (1:18360105). Test (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.Server: Msg 8928, Level 16, State 1, Line 7Object ID 751341741, index ID 0: Page (1:18659809) could not be processed. See other errors for details.Server: Msg 8939, Level 16, State 1, Line 7Table error: Object ID 751341741, index ID 0, page (1:18659809). Test (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.Server: Msg 8928, Level 16, State 1, Line 7Object ID 751341741, index ID 0: Page (1:18699033) could not be processed. See other errors for details.Server: Msg 8939, Level 16, State 1, Line 7Table error: Object ID 751341741, index ID 0, page (1:18699033). Test (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.CHECKDB found 0 allocation errors and 7 consistency errors in table 'inv_detail_rtest' (object ID 751341741).CHECKDB found 0 allocation errors and 7 consistency errors in database 'ICBM'.repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (ICBM noindex).Table inv_detail_rtest is objectid 751341741.I did DBCC PAGE on each of the pages listed and looked at the few rows that are bad. Each row is about 800 bytes so there are not many rows per page therefore not many bad rows.*** How can I run DBCC CHECKDB with REPAIR DATA LOSS?? or how do I manually delete the bad pages. *** I get "You are in recovery bypass mode" and can't do anything and I can't get Single User mode to stick.exec sp_configure 'allow updates', 1exec sp_dboption 'ICBM', 'single_user', 'true'RECONFIGURE WITH OVERRIDEDBCC CHECKDB('ICBM', REPAIR_ALLOW_DATA_LOSS)Configuration option 'allow updates' changed from 1 to 1. Run the RECONFIGURE statement to install.Server: Msg 7919, Level 16, State 2, Line 7Repair statement not processed. Database needs to be in single user mode.DBCC execution completed. If DBCC printed error messages, contact your system administrator.It's a 330 GB database and I have a backup from Tuesday night but I don't have 330GB available on this server to restore the Backup Exec data. I can't find a way to restore the pages I need from Backup Exec. I don't have extra slots in the RAID cage and I don't have the drives even if I did and it's a 2 hour drive to the datacenter. There was a power failure Wednesday afternoon that caused the issue. I'm moving to a new data center ASAP, by the way. I spent yesterday on google.THANKS!!Fri, 01 Oct 2010 09:08:49 GMTlinkusnethttp://www.sqlservercentral.com/Forums/Topic680617-265-1.aspxHello,When I run checkdb, I got this errorDBCC results for 'agent_band_details_ASH699'.Server: Msg 2576, Level 16, State 1, Line 1IAM page (0:0) is pointed to by the previous pointer of IAM page (1:394336) object ID 229575856 index ID 4 but was not detected in the scan.There are 1242 rows in 12 pages for object 'agent_band_details_ASH699'.We deleted the agent_band_details_ASH699 table cause it was a temporary table for our project.but the error is still there but the table has changed. I Think checkdb is laughing at me, or just kidding me.DBCC results for 'agent'.Server: Msg 2576, Level 16, State 1, Line 1IAM page (0:0) is pointed to by the previous pointer of IAM page (1:394336) object ID 229575856 index ID 4 but was not detected in the scan.There are 17297 rows in 394 pages for object 'agent'.Here another output with tableresults2576 16 1 IAM page (0:0) is pointed to by the previous pointer of IAM page (1:394336) object ID 229575856 index ID 4 but was not detected in the scan. repair_allow_data_loss 0 7 229575856 4 0 0 0 1 394336 0 2The repairlevel is at repair_allow_data_loss,is this mean that I cannot repair it without loosing data ?version is:Microsoft SQL Server 2000 - 8.00.2187 (Intel X86) Mar 9 2006 11:38:51 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)I want to know what is IAM page error, or meaning, I want to debug deeper as you can show me.Thanks for your timeFri, 20 Mar 2009 11:53:20 GMThugues.gauthierhttp://www.sqlservercentral.com/Forums/Topic976026-265-1.aspxI have a client who somehow ended up with a corrupted master database. Before we did anything I made copies of everything and then proceeded with RebuildM as oulined here: http://msdn.microsoft.com/en-us/library/aa197950%28SQL.80%29.aspxAfter letting it run overnight it became apparent that the utility was never going to finish.We decided to set up a new SQL Server instance on some spare hardware and attach the databases they needed for their applications on that. We installed SQL 2008 and that is running fine.We had quite a bit of custom DTS on the server that crashed. Since I have a clean copy of their MSDB database, how would I go about getting at the packages? Ideally we'd like to rewrite everything in SSIS eventually but to do that I'll still need to reference the original DTS. I've attached the MSDB database to a SQL 2000 instance here in our shop but I'm not sure how to get at those DTS packages. I know they're in sysdtspackages but I need to get them out as .dts files so i can, at the very least, run them from the file system on the new server.Thu, 26 Aug 2010 17:04:22 GMTScott D. Jacobsonhttp://www.sqlservercentral.com/Forums/Topic539192-265-1.aspxHello,we have the following Problem in Enterprise Manager:If i want to open tree for specific Database, the following Error appears:objDatabase.Parent is null or not an ObjectWe can still access Database.This only occurs in one Database, all other Database the tree could be opened.Any idea or solution?greets Jürgen BratzkeWed, 23 Jul 2008 06:37:57 GMTjbratzkehttp://www.sqlservercentral.com/Forums/Topic950757-265-1.aspxI have a problem with my database going suspect, this does not happen everyday, it can three days or once a month.the error logs produced are shown below17052 :Device activation error. The physical file name 'd:\\MSSQL\data\"users database".mdf' may be incorrect.17204 :FCB::Open failed: Could not open device d:\\MSSQL\data\"users database".mdf for virtual device number (VDN) 1.17207 :udopen: Operating system error 32(error not found) during the creation/opening of physical device d:\\MSSQL\data\"users database".mdf.where "users database" is my database.We have other databases backing without a problem, it just seems to happen to this one.SQL backups are taken every night so we thought this might be the problem, but stopping them didn't help,they seem to be happening at about 3:00 in the morning.if anybody has any ideas it would be appreciatedMon, 12 Jul 2010 07:51:41 GMTclucasihttp://www.sqlservercentral.com/Forums/Topic949537-265-1.aspxWe have a database that was put in 'suspect' mode, it is now in 'emergency' mode; using DBCC CHECKDB the problem table was identified.I tried using DBCC CHECKTABLE ( 'MyTable', REPAIR_ALLOW_DATA_LOSS ) WITH ALL_ERRORMSGS but it was not allowedI've had messages that it needs to be in single user mode, which I then altered the database to single_user mode but since it is still in emergency mode it ignores the single user mode.I cannot drop or truncate the table -- it will not let me drop the primary key constraint and clustered index to rebuild that way either.Does anyone know any way to get around this? I hate to have to rebuild the whole database just because of one bad table.Thank you in advance for your assistance.Thu, 08 Jul 2010 12:52:26 GMTEllen-477471http://www.sqlservercentral.com/Forums/Topic940912-265-1.aspxFolksThis is my first postQ)One of our Production Database is frequently going to suspect(it is happening actually when scheduled nightly backup happening through Mplanwhen i checked in the error logs it is showing the following errorDatabase suspect (xyz) sqlserver error log Message1)Operating system error 32(The process cannot access the file because it is being used by another process.) during the creation/opening of physical device2)FCB::Open failed: Could not open device F:ewfolder\data\xyz_Data.MDF for virtual device number (VDN) 1.3)[298] SQLServer Error: 4060, Cannot open database requested in loginWhen i restarted the production Server then DB is up & Online Let me Know the cause of Suspect States. & How to analyze the root cause for this issue.and i know every time restarting the Production is not recommended but (time Being its restarted.)At the same time My Temp Db is also growing .is there any relation between suspect status With tempdbwe are using sqlserver 2000 Your replies will be Appreciated Tue, 22 Jun 2010 04:51:52 GMTjamessdbahttp://www.sqlservercentral.com/Forums/Topic933125-265-1.aspxHi,Server giving the below eror message while running the dbcc checktable(mytable).Server: Msg 2511, Level 16, State 2, Line 1Table error: Object ID 2105058535, Index ID 0. Keys out of order on page (1:2528), slots 0 and 1.Server: Msg 2511, Level 16, State 1, Line 1Table error: Object ID 2105058535, Index ID 4. Keys out of order on page (1:142427), slots 32 and 33.Server: Msg 2511, Level 16, State 1, Line 1Table error: Object ID 2105058535, Index ID 4. Keys out of order on page (1:142427), slots 34 and 35.DBCC results for 'MyTable'.There are 12123 rows in 740 pages for object 'MyTable'.CHECKTABLE found 0 allocation errors and 3 consistency errors in table 'MX_Properties' (object ID 2105058535).repair_rebuild is the minimum repair level for the errors found by DBCC CHECKTABLE (SERVer.dbo.mytable ).Please guide to resolve this issue in better way. thanks in advance.Fri, 04 Jun 2010 22:54:20 GMTsudhakarahttp://www.sqlservercentral.com/Forums/Topic923191-265-1.aspxBefore I fully describe the problem let me describe the environment. In this scenario, the SQL server was having hardware problems for months. These problems were not reported. Currently, 2 of the 5 drives have numerous hardware errors. When we try to copy the MDF from the SQL Server to an external drive an error occurs at the end of the copy. The tape backup hasn't run for months. Again, not reported. There are no usable tape backups. The last usable tape is from 2009. I know this is hard to believe. I was in disbelief when I was told the story but it is true. I have installed a copy of SQLExpress 2008 on a workstation along with 2008 Management Studio. When I try to attach the MDF from the external drive to SQLExpress 2008, an error occurs. It says in part "SQL server has detected a logical-consistency I/O error:Incorrect PageID(a detailed explanation of which page and database is in the actual message.) This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check(DBCC_CheckDB)..."I found DBCC_CHeckDB in the Books Online. But it seems that the database must be attached to use this utility.Can any one offer any suggestions on how to proceed?thanks,patMon, 17 May 2010 16:31:31 GMTmpdillonhttp://www.sqlservercentral.com/Forums/Topic918442-265-1.aspxHmmm...we have an old SQL 2000 server system, currently patched to SP4 and Hotfix 2282, which has suddenly started returning this type of error:[font="Courier New"][i]DESCRIPTION: Error: 0, Severity: 19, State: 0SqlDumpExceptionHandler: Process 71 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.[/i][/font]When digging in the windows logs, I found this:[font="Courier New"][i]Event Type: ErrorEvent Source: MSSQLSERVEREvent Category: (2)Event ID: 17055Date: 5/7/2010Time: 11:04:25 PMUser: N/AComputer: SQLSERVERDescription:17066 :SQL Server Assertion: File: <proc.c>, line=1606 Failed Assertion = 'm_activeSdesList.Head () == NULL'. .. [/i][/font]I am curious if anyone knows what this could be? I have DBCC CheckDB'd the databases, including system ones, and they passed fine. Our app folks say there has been nothing new going on and no obvious hardware problems I can detect in the windows logs.Any suggestions as this seems to be quite obscure? Most stuff I've seen online says to patch, but this is already at the latest SP4 for SQL 2000. As this is production, I hesitate to reboot the server without a good reason.Thanks in advance.Fri, 07 May 2010 21:53:24 GMTGabyYYZhttp://www.sqlservercentral.com/Forums/Topic899389-265-1.aspxWe've had a problem on a production system yesterday where it looks like a problem in a job running at 8:18am issued a BEGIN TRANSACTION that may not have had a corresponding COMMIT issued.The job appears to have completed successfully, as do the subsequent 4 hours of batch running (all using SPID 68). We can see the batch finish at 12:31 and relinquish SPID 68. This SPID was then used by 3 other users in the next 5 minutes, the last of whom issued a ROLLBACK command, and this seems to have then rolled back all changes since 8:18 on this SPID.We had a basic trace running which is how I can see this rollback, but I don't understand how this will have caused the issue, as the SPID had been handed off to a seperate user at this stage. Is it feasible for this rollback scenario to happen, or did SQL simply "tidy up" the open transaction when the batch relinquished SPID 68? If it did "tidy up" why is there no evidence of this in Server Logs?I've been through the Server Logs and Windows event logs for the hours in question and can't find any trace of a rollback other than the one issued at 12:34 by a different user.I'm now at the stage where to try and prove what happened one way or another I'm looking at restoring a backup from early yesterday morning and rolling the transaction logs in to try and pin down what happened and when. If it was an issue with the application I need to prove this so I can hand it back to the developers.Are either of the scenarios I've outlined above feasible? If not, does anyone have any other ideas?We're using SQL Server 2000 Enterprise Build 80.0.2055 running on a Windows 2003 64 bit Server, and the batch is controlled from a VB.NET job manager process running on a seperate web server.Any help would be appreciated.AndyThu, 08 Apr 2010 04:12:45 GMTAndeavourhttp://www.sqlservercentral.com/Forums/Topic903315-265-1.aspxHi .. Missing last 2 Days records ..How can i recover ... We don't have any differtial backUp. The Last Full backUp taken was 3 days ago..But the LDF is upto date (modified Date )..Is there a Chance to recover the missing data ...Wed, 14 Apr 2010 10:08:37 GMTJohn Paul-702936http://www.sqlservercentral.com/Forums/Topic900745-265-1.aspxI've got a database that I just found out about, it happend when a disk failed and as a result there were torn pages, which generates DBCC errors and chain errors. there errors are on index level 0, so they are in the table themselves as well as some of the indexessince i just found out about it, there were no backups running so I cannot repair the pages. I believe my only option is a dbcc checkdb(dbname) with repair_allow_data_loss, before I do that I would like to take a backup of the DB. I know SQL 2008 and 2005 have an option where you can say Continue_After_Error, but when I typed that in SQL through an exception.Is there a SQL 2000 command that is similar to continue_after_error for database backups? I didn't see one in BOL. Thanks!Fri, 09 Apr 2010 11:53:42 GMTSQLBallshttp://www.sqlservercentral.com/Forums/Topic899192-265-1.aspxI'm trying to attach a database using the wizard and I'm getting an error message:---------------------------Microsoft SQL-DMO (ODBC SQLState: HY000)---------------------------Error 7987: A possible database consistency problem has been detected on database 'XXXX'. DBCC CHECKDB and DBCC CHECKCATALOG should be run on database 'XXXX'.---------------------------OK ---------------------------I'd love to run the commands it tells me to run, but since I am unable to attach the database, I am unable to run these commands. How do I get past this error in order to attach?Wed, 07 Apr 2010 19:22:46 GMTK Curriehttp://www.sqlservercentral.com/Forums/Topic895161-265-1.aspxHi,I have a strange issue related to this error. We're using MSDE 2000 db. After a power failure, our db logs reported this error and the application no longer worked.We copied the dbf/ldf files off onto another machine and was able to attached and query tables w/o any issues or data loss. To confirm the db was good, we moved the files again onto another system and, again, attached using enterprise manager (2000) w/o issues. Ran update stats/check integrity w/o issues.We placed the db back onto the original system and it still threw the suspect errors. We then uninstall the app (which removes the MSDE) and reinstalled it fresh just to make sure we got new default db files in place (master, model, etc.). The new app db worked fine, however, once we restored the problem app db, it marked it suspect again.I can't seem to figure out why we cannot get this db to work on this machine. Any suggestions?Thu, 01 Apr 2010 11:55:06 GMTss1011http://www.sqlservercentral.com/Forums/Topic892675-265-1.aspxhi thereplz help me i am using primavera p6 on windows 7 32 bit i work on it 10 days suddnly its stop working my all work stuck indside how i can get back data if p6 is not working properlythanks.Tue, 30 Mar 2010 06:37:26 GMTandleeb_447