March 22, 2009 at 3:32 pm
3] Database cdi_commerce: Check Data and Index Linkage...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 8964: [Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 1136059133. The text, ntext, or image node at page (1:1092), slot 46, text ID 4243624165376 is not referenced.
The following errors were found:
[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 1136059133. The text, ntext, or image node at page (1:1092), slot 46, text ID 4243624165376 is not referenced.
[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 1136059133. The text, ntext, or image node at page (1:1104), slot 67, text ID 4243759693824 is not referenced.
March 22, 2009 at 4:16 pm
Error 8964 is corruption in LOB (Large Objects); recommended solution is to run DBCC CHECKDB WITH ALLOW_DATA_LOSS.; you can read more about data corruption errors at http://www.sqlservercentral.com/articles/65804/.
Thanks.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 22, 2009 at 5:11 pm
Can you please give an example how to do it DBCC CHECKDB WITH ALLOW_DATA_LOSS.
Name of the database Julia. Thank you
March 22, 2009 at 5:59 pm
To repair using the allow data loss option you execute following
USE [master]
GO
DBCC CHECKDB (Julia, REPAIR_ALLOW_DATA_LOSS)
GO
Before you execute that can you please execute following and attach the results in a text file?
DBCC CHECKDB (Julia) WITH ALL_ERRORMSGS, NO_INFOMSGS
Another question, do you have a good backup of your database?
Thanks.
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 22, 2009 at 6:41 pm
Hi,Thank you, I have couple questions:
1. So in order for me to run to repair db, I need:
DBCC CHECKDB (Julia) WITH ALL_ERRORMSGS, NO_INFOMSGS
2.USE [master]
GO
DBCC CHECKDB (Julia, REPAIR_ALLOW_DATA_LOSS)
GO
Right?
How much data will I loose? Can I get an error message what data I lost and what happend to the data?
March 22, 2009 at 7:17 pm
yulichka (3/22/2009)
Hi,Thank you, I have couple questions:1. So in order for me to run to repair db, I need:
DBCC CHECKDB (Julia) WITH ALL_ERRORMSGS, NO_INFOMSGS
This is not repair so you can see all the error messages; I saw another post it seems you have many other errors. This will give us a complete picture of issues on your database.
2.USE [master]
GO
DBCC CHECKDB (Julia, REPAIR_ALLOW_DATA_LOSS)
GO
Right?
How much data will I loose? Can I get an error message what data I lost and what happend to the data?
This error you posted indicates the data is already lost; so you can't recover it. As to what was lost, it based on the Object ID ...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 8964: [Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 1136059133. The text, ntext, or image node at page (1:1092), ...
This tells us that the data was lost from Object ID 1136059133, you can find the object name with SELECT object_name(1136059133). The Page information tells us that it was in File ID 1, Page 1092.
Did you have a hard drive issue recently?
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 22, 2009 at 7:35 pm
1.Can you please give me full select statment how to find an object_name.
2.Also how can I find what is file id 1 and page 1092. I really appreciate your help
March 22, 2009 at 8:39 pm
I will find out if I had a hard drive issue, why? is it happening because of the hard drive?
March 22, 2009 at 9:00 pm
It says that in order to run dbcc repair that my db needs to be in single mode,but my db in multi user mode, if I switch our web customers won't be able to use the db,what should I do?
March 23, 2009 at 1:47 am
yulichka (3/22/2009)
It says that in order to run dbcc repair that my db needs to be in single mode,but my db in multi user mode, if I switch our web customers won't be able to use the db,what should I do?
Any form of repair requires single user because the algorithms are complex enough already. Trying to repair a DB that others are using is near impossible.
If you really do need to run repair, you'll have to take the system offline for a while.
Before you run repair (I hope you haven't already), see my comments to you here - http://www.sqlservercentral.com/Forums/Topic681169-146-1.aspx - and if you're not sure of the interpretation, post the full output of the following command.
DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 10 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply