Database Integrity Error - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Database Integrity Error

Author

Topic

DBA007
Posting Yak Master

145 Posts

Posted - 2010-01-18 : 10:14:33

Dear Team,
My MPlan have failed stating the below error,as I ran DBCC Checkdb('dbname')with no_infomsgs,all_errormsg to check any errors,I didnt get any errors except the "commands completed succesfully" any suggestion!!

Executed as user: XXXX\SQLADMIN. ... complete End Progress Progress: 2010-01-17 00:20:01.33
Source: Check Database Integrity Executing query "USE [P1] ".: 50% complete End Progress
Progress: 2010-01-17 00:20:07.79 Source: Check Database Integrity
Executing query "DBCC CHECKDB WITH NO_INFOMSGS ".: 100% complete End Progress
Progress: 2010-01-17 00:20:07.80 Source: Check Database Integrity
Executing query "USE [D1] ".: 50% complete End Progress
Progress: 2010-01-17 00:20:23.50 Source: Check Database Integrity
Executing query "DBCC CHECKDB WITH NO_INFOMSGS ".: 100% complete End Progress
Progress: 2010-01-17 00:20:23.52 Source: Check Database Integrity
Executing query "USE [S1] ".: 50% complete End Progress
Progress: 2010-01-17 00:20:29.16 Source: Check Database Integrity
Executing query "DBCC CHECKDB WITH NO_INFOMSGS ".: 100% complete End Progress
Progr... The package execution fa... The step failed.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-01-18 : 11:29:15

Asked and answered: http://www.sqlservercentral.com/Forums/Topic849189-146-1.aspx

--
Gail Shaw
SQL Server MVP

DBA007
Posting Yak Master

145 Posts

Posted - 2010-01-19 : 13:33:10

I get the same error mess:
complete End Progress Progress: 2010-01-17 00:20:01.33
Source: Check Database Integrity Executing query "USE [P1] ".: 50% complete End Progress
Progress: 2010-01-17 00:20:07.79 Source: Check Database Integrity
Executing query "DBCC CHECKDB WITH NO_INFOMSGS ".: 100% complete End Progress
Progress: 2010-01-17 00:20:07.80 Source: Check Database Integrity
Executing query "USE [P2] ".: 50% complete End Progress
Progress: 2010-01-17 00:20:23.50 Source: Check Database Integrity
Executing query "DBCC CHECKDB WITH NO_INFOMSGS ".: 100% complete End Progress
Progress: 2010-01-17 00:20:23.52 Source: Check Database Integrity
Executing query "USE [P3] ".: 50% complete End Progress
Progress: 2010-01-17 00:20:29.16 Source: Check Database Integrity
Executing query "DBCC CHECKDB WITH NO_INFOMSGS ".: 100% complete End Progress
Progr... The package execution fa... The step failed.

DBA007
Posting Yak Master

145 Posts

Posted - 2010-01-19 : 16:58:20

Team,
I got error as fallows.for reorganizing index.
Executing the query "ALTER INDEX [PK_ume] ON [dbo].[ume] REORGANIZE WITH ( LOB_COMPACTION = ON )
" failed with the following error: "A severe error occurred on the current command. The results, if any, should
be discarded.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly,
parameters not set correctly, or connection not established correctly.

For the Cleanup task Errror MSG:

Executing the query "EXECUTE master.dbo.xp_delete_file 1,N'',N'txt',N'2009-12-22T01:28:11'
" failed with the following error: "Error executing extended stored procedure: Invalid Parameter". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources