Solved

SQL Backup DBCC errors

Posted on 2009-05-11
7
726 Views
Last Modified: 2012-05-06
I have Symantec backup Exec tool that backups databases on scheduled time to some other server. Now during backup there are some errors which I have listed below.
Backup- IHS-MAIN-SQL-05
An unknown or unexpected database error occurred while attempting a DBCC.
DBCC results for 'P83'.
An unknown or unexpected database error occurred while attempting a DBCC.
DBCC results for 'P61'.
An unknown or unexpected database error occurred while attempting a DBCC.
DBCC results for 'P60'.
An unknown or unexpected database error occurred while attempting a DBCC.
DBCC results for 'P56'.
An unknown or unexpected database error occurred while attempting a DBCC.
DBCC results for 'P54'.

 And I ran some DBCC commands and the errors went away.
The command that I use were
DBCC CHECKDB(P003) WITH NO_INFOMSGS, ALL_ERRORMSGS
(That showed me some errors)
The In-row data RSVD page count for object "drug_allergy", index ID 0, partition ID 66563254910976, alloc unit ID 66563254910976 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.
CHECKDB found 0 allocation errors and 1 consistency errors in table 'drug_allergy' (object ID 1015674666).
Msg 2508, Level 16, State 3, Line 1
The In-row data RSVD page count for object "lab_test", index ID 0, partition ID 70667134631936, alloc unit ID 70667134631936 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.
CHECKDB found 0 allocation errors and 1 consistency errors in table 'lab_test' (object ID 1078294901).
Msg 2508, Level 16, State 3, Line 1
The In-row data RSVD page count for object "repos_field_query", index ID 0, partition ID 104268611518464, alloc unit ID 104268611518464 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.
CHECKDB found 0 allocation errors and 1 consistency errors in table 'repos_field_query' (object ID 1591012749).
CHECKDB found 0 allocation errors and 4 consistency errors in database 'P003'.

Then I ran     DBCC UPDATEUSAGE(database_name)
And the errors went away. So now again in the Symantec backup Exec the backup is scheduled today at 8:00 PM. So does anybody know that will there be any errors now or there will still be errors. Please help me.
0
Comment
Question by:aatishpatel
7 Comments
 
LVL 31

Accepted Solution

by:
RiteshShah earned 500 total points
Comment Utility
Run DBCC Checkdb on database and show me the message it shows
0
 
LVL 6

Expert Comment

by:PIERCGG
Comment Utility
Have you attempted a SQL Server backup to see if you get the same error messages as when you run the Symantec backup?
0
 

Author Comment

by:aatishpatel
Comment Utility
No i haven't attempt to backup thru Symantec because its been scheduled today at 8:00 PM
0
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 

Author Comment

by:aatishpatel
Comment Utility
after i ran DBCC CHECKDB   below are the results


DBCC results for 'sys.sysguidrefs'.
There are 2 rows in 1 pages for object "sys.sysguidrefs".
DBCC results for 'sys.sysqnames'.
There are 432 rows in 4 pages for object "sys.sysqnames".
DBCC results for 'sys.sysxmlcomponent'.
There are 663 rows in 4 pages for object "sys.sysxmlcomponent".
DBCC results for 'sys.sysxmlfacet'.
There are 289 rows in 2 pages for object "sys.sysxmlfacet".
DBCC results for 'sys.sysxmlplacement'.
There are 827 rows in 5 pages for object "sys.sysxmlplacement".
DBCC results for 'sys.sysobjkeycrypts'.
There are 855 rows in 26 pages for object "sys.sysobjkeycrypts".
DBCC results for 'sys.sysasymkeys'.
There are 0 rows in 0 pages for object "sys.sysasymkeys".
DBCC results for 'sys.syssqlguides'.
There are 0 rows in 0 pages for object "sys.syssqlguides".
DBCC results for 'sys.sysbinsubobjs'.
There are 0 rows in 0 pages for object "sys.sysbinsubobjs".
DBCC results for 'sys.syspalvalues'.
There are 383 rows in 3 pages for object "sys.syspalvalues".
DBCC results for 'sys.spt_server_info'.
There are 27 rows in 1 pages for object "sys.spt_server_info".
DBCC results for 'sys.spt_datatype_info'.
There are 66 rows in 1 pages for object "sys.spt_datatype_info".
DBCC results for 'sys.role_permissions'.
There are 169 rows in 2 pages for object "sys.role_permissions".
DBCC results for 'sys.sysbinpals'.
There are 45 rows in 1 pages for object "sys.sysbinpals".
DBCC results for 'sys.syscolrdb'.
There are 10598 rows in 170 pages for object "sys.syscolrdb".
DBCC results for 'sys.spt_provider_types'.
There are 27 rows in 1 pages for object "sys.spt_provider_types".
DBCC results for 'sys.syspalnames'.
There are 112 rows in 1 pages for object "sys.syspalnames".
DBCC results for 'sys.spt_permission_names'.
There are 5 rows in 1 pages for object "sys.spt_permission_names".
DBCC results for 'sys.sysobjrdb'.
There are 1741 rows in 24 pages for object "sys.sysobjrdb".
DBCC results for 'sys.spt_datatype_info_ext'.
There are 10 rows in 1 pages for object "sys.spt_datatype_info_ext".
DBCC results for 'sys.queue_messages_1977058079'.
There are 0 rows in 0 pages for object "sys.queue_messages_1977058079".
DBCC results for 'sys.queue_messages_2009058193'.
There are 0 rows in 0 pages for object "sys.queue_messages_2009058193".
DBCC results for 'sys.queue_messages_2041058307'.
There are 0 rows in 0 pages for object "sys.queue_messages_2041058307".
CHECKDB found 0 allocation errors and 0 consistency errors in database 'mssqlsystemresource'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
0
 
LVL 6

Expert Comment

by:bull_rider
Comment Utility
I dont think any more errors will pop up. You are good to go. :)
0
 

Author Comment

by:aatishpatel
Comment Utility
thanx bull rider. i will let you know when the backup is done.
0
 

Author Closing Comment

by:aatishpatel
Comment Utility
thanx
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now