Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sql_newbie121
Yak Posting Veteran
52 Posts |
 Posted - 2009-12-10 : 11:01:04
|
| I get following error in my daily backup plan. How can i resolve this issue:=====================MessageExecuted as user: SA. ...on 9.00.4035.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:56:58 AM Progress: 2009-12-10 08:56:59.16 Source: {1414FEBC-6362-48C4-8C79-DC4EC19DB930} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress Progress: 2009-12-10 08:56:59.40 Source: Check Database Integrity Task Executing query "USE [master] ".: 50% complete End Progress Progress: 2009-12-10 08:57:00.08 Source: Check Database Integrity Task Executing query "DBCC CHECKDB WITH NO_INFOMSGS ".: 100% complete End Progress Progress: 2009-12-10 08:57:00.08 Source: Check Database Integrity Task Executing query "USE [model] ".: 50% complete End Progress Progress: 2009-12-10 08:57:00.33 Source: Check Database Integrity Task Executing query "DBCC CHECKDB WITH NO_INFOMSGS ".: 100% complete End Progress Progress: 2009-12-10 0... The package execution fa... The step failed.=======================================================Your help is appreciated. |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-12-10 : 11:30:01
|
Please run the following and post the full output.DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS Do you have a clean backup? (One from before the errors started)--Gail ShawSQL Server MVP |
 |
|
|
sql_newbie121
Yak Posting Veteran
52 Posts |
Posted - 2009-12-10 : 11:57:55
|
| Gail:Here is the output: Command(s) completed successfully. This is what i got it. Nothing else is there. I do have a clean back up of yesterday, the backup job failed last night at 1:00 AM. Daily full backup runs at 1 am every day. Let me know if there is anything that i can do to fix this issue. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-12-10 : 12:27:24
|
| Well, if the manually run DB integrity completes OK, then everything looks OK.You did run that on all databases?There's no way to tell, from the error there, why the job failed. Could have been something unrelated. If it fails again, then it may be time to worry. Can you maybe modify the package to log full output for a while, so if anything happens we can see full error.What I've seen happen before is an integrity check fails. The next job is index rebuild, which fixes the corruption, so when a manual check is done there's nothing wrong.To be safe, check the windows event log, see if there are any hardware-related errors there.--Gail ShawSQL Server MVP |
|
|
|
sql_newbie121
Yak Posting Veteran
52 Posts |
Posted - 2009-12-10 : 13:36:48
|
| Gail:I did run on all databases. They are OK. I did find the problem now, there has been a new database added yesterday and that database was not added in it. When i added the new database and run the job manually, it succedded. I did not know that who added this database. We are 4 DBAs and any one of them could have added. I am on Pager so i have to resolve it. It did work now. I have a question though, is there a way that can pick up the new database in the maintenance plan or if any database is removed from the server or if the database is in the restoring mode ( in logshipping set up)? This way if anybody added any database or dropped any database, job would not fail.Thanks for your help. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-12-11 : 01:36:22
|
| Not that I'm aware of from a maint plan. That said, I've never used them much.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
|
|
DBCC CHECK DB Integrity Check failed