Dbcc Error 1073548784
Contents |
account only takes a few minutes. Join Now I have been looking through my SQL Maintenance plans and I saw that for the past few days I am getting an error while checking the integrity. a database snapshot cannot be created because it failed to start dbcc checkdb The error message that it comes up with(see the title) after a bit of research
Msg 7926, Level 16, State 1, Line 1
comes back with nothing. I am not sure how I should go about resolving this as all the other maintenance plans are create a database snapshot (transact-sql) working just fine. Any help on this topic would be greatly appreciated. Reply Subscribe RELATED TOPICS: Query sql 2008R2 SQL 2008R2 32-bit to 64-bit Upgrade SQL Management Studio Error when running Database integrity job.   2 Replies
Dbcc Checkdb Snapshot Size
Datil OP GerardMainardi Jan 17, 2014 at 2:22 UTC Could you please post the full error message? Hopefully SQL is giving you more than just that number. 0 Thai Pepper OP Robert L Davis Jan 17, 2014 at 3:16 UTC That's just the error code for a maintenance plan failing. We need the actual error from the integrity check. If you don't have that information in the job history, you dbcc checkdb fails will need to run DBCC CHECKDB on the database to get it. If you don't know which database it failed on, run it on all of them. The command to use is: DBCC CHECKDB( Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2005 » Administering » DBCC CHECKDB Consistency Error 15 posts,Page 1 of 212»» DBCC CHECKDB Consistency Error Rate Topic Display Mode Topic Options Author Message MostInterestingManMostInterestingMan Posted Friday, May 14, 2010 8:39 AM SSC Veteran Group: dbcc updateusage General Forum Members Last Login: Wednesday, February 5, 2014 8:31 AM Points: 243, Visits: 601 I got a consistency error alert this morning for one of my databases. Below is the specific error https://community.spiceworks.com/topic/432661-sql-2008r2-check-database-integrity-error-1073548784 message:Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3854, State 1: Attribute (parent_object_id=210099789) of row (object_id=226099846) in sys.objects has a matching row (object_id=210099789) in sys.objects (type=S ) that is invalid.Usually I am use to seeing consistency errors that suggest the type of repair to attempt to recovery the data if possible. Can anyone please advise as to how to handle the above error http://www.sqlservercentral.com/Forums/Topic922090-146-1.aspx in respect to attempting to recover the data? I do have backups but it will take couple of days plus a stock pile of paper work to go down that path.Thanks, MCTS: BI 2008, MCITP: BI 2008Stay Thirsty My Friends Post #922090 SQLBallsSQLBalls Posted Friday, May 14, 2010 9:03 AM Old Hand Group: General Forum Members Last Login: Tuesday, January 19, 2016 9:20 AM Points: 386, Visits: 630 Have you run an integrity check? Twitter: @SQLBallsBlog: http://www.SQLBalls.com Post #922117 SQLBallsSQLBalls Posted Friday, May 14, 2010 9:06 AM Old Hand Group: General Forum Members Last Login: Tuesday, January 19, 2016 9:20 AM Points: 386, Visits: 630 Read this, it would indicate a metadate errorhttp://www.sqlservercentral.com/articles/Corruption/65804/this article links to thishttp://www.sqlskills.com/BLOGS/PAUL/post/TechEd-Demo-Using-the-SQL-2005-Dedicated-Admin-Connection-to-fix-Msg-8992-corrupt-system-tables.aspxPaul Randal is the man. He wrote DBCC CHECKDB, I would treat whatever he says as gold. Twitter: @SQLBallsBlog: http://www.SQLBalls.com Post #922122 MostInterestingManMostInterestingMan Posted Friday, May 14, 2010 12:43 PM SSC Veteran Group: General Forum Members Last Login: Wednesday, February 5, 2014 8:31 AM Points: 243, Visits: 601 Bradley,Thanks a million for the links - great pointers!!Yes Paul is "de MAN" on this topic and I should have visited his blog before posting. I will implement so Version 11.0.3128 Report was generated on "*****\*****". Maintenance Plan: Database Maintenance Duration: 00:46:34 Status: Warning: One or more tasks failed. http://www.networksteve.com/forum/topic.php/Failed:(-1073548784)_Executing_the_query_%22DBCC_CHECKDB/?TopicId=121874&Posts=1 Details: Check Database Integrity (*****\****) Check Database integrity on Local server connection Databases that have a compatibility level of 70 (SQL Server version 7.0) will be skipped. Databases: All databases Include indexes Task start: 2016-04-22T21:00:10. Task end: 2016-04-22T21:43:50. Failed:(-1073548784) Executing the query "DBCC CHECKDB(N'SharePoint2013Prod') WITH NO_INFOM..." failed with the following error: "Table error: Object ID 1762105318, dbcc checkdb index ID 1, partition ID 72057594141081600, alloc unit ID 72057594062897152 (type LOB data). The off-row data node at page (1:601659), slot 37, text ID 302626177024 is not referenced. Table error: Object ID 1762105318, index ID 1, partition ID 72057594141081600, alloc unit ID 72057594062897152 (type LOB data). The off-row data node at page (1:601659), slot 65, a database snapshot text ID 302628732928 is not referenced. Table error: Object ID 1762105318, index ID 1, partition ID 72057594141081600, alloc unit ID 72057594062897152 (type LOB data). The off-row data node at page (1:601661), slot 63, text ID 302628405248 is not referenced. Table error: Object ID 1762105318, index ID 1, partition ID 72057594141081600, alloc unit ID 72057594062897152 (type LOB data). The off-row data node at page (1:601662), slot 13, text ID 302626439168 is not referenced. Table error: Object ID 1762105318, index ID 1, partition ID 72057594141081600, alloc unit ID 72057594062897152 (type LOB data). The off-row data node at page (1:601672), slot 25, text ID 302650032128 is not referenced. Table error: Object ID 1762105318, index ID 1, partition ID 72057594141081600, alloc unit ID 72057594062897152 (type LOB data). The off-row data node at page (1:601672), slot 33, text ID 302650949632 is not referenced. Table error: Object ID 1762105318, index ID 1, partition ID 72057594141081600, alloc unit ID 72057594062897152 (type LOB data). The off-row data node at page (1:601673), slot 3 be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 06 Oct 2016 15:04:11 GMT by s_hv995 (squid/3.5.20)Dbcc Checkdb Tablock
The Database Could Not Be Exclusively Locked To Perform The Operation.