September 10, 2009 at 4:56 am
Currently have 2 maintenance plans that run weekly on our server. Last night they both failed. I have attached a copy of the report logs.
NEW COMPONENT OUTPUT
Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3042
Report was generated on "CHP-S-DW-001".
Maintenance Plan: DB Maintainance plan wed to fri
Duration: 01:13:07
Status: Warning: One or more tasks failed..
Details:
Check Database Integrity (CHP-S-DW-001)
Check Database integrity on Local server connection
Databases: Adhoc_Requests,BEDB,Capacity_model_0910,Continuing_care,CRX_et,CRX_py,Data_Validation,Data_Warehouse_2,Dental,ePACT,exceptional_treatments,JSNA,Metrics,NSTS,Primary_Care,Public_health
Include indexes
Task start: 2009-09-09T22:00:03.
Task end: 2009-09-09T22:00:13.
Failed:(-1073548784) Executing the query "DBCC CHECKDB WITH NO_INFOMSGS
" failed with the following error: "There is insufficient system memory to run this query.
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Command:USE [Adhoc_Requests]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [BEDB]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Capacity_model_0910]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Continuing_care]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [CRX_et]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [CRX_py]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Data_Validation]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Data_Warehouse_2]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Dental]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [ePACT]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [exceptional_treatments]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [JSNA]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Metrics]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [NSTS]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Primary_Care]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Public_health]
GO
DBCC CHECKDB WITH NO_INFOMSGS
Check Database Integrity (CHP-S-DW-001)
Check Database integrity on Local server connection
Databases: Adhoc_Requests,BEDB,Capacity_model_0910,Continuing_care,CRX_et,CRX_py,Data_Validation,Data_Warehouse_2,Dental,ePACT,exceptional_treatments,JSNA,Metrics,NSTS,Primary_Care,Public_health
Include indexes
Task start: 2009-09-09T22:00:03.
Task end: 2009-09-09T22:00:22.
Failed:(-1073548784) Executing the query "DBCC CHECKDB WITH NO_INFOMSGS
" failed with the following error: "There is insufficient system memory to run this query.
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Command:USE [Adhoc_Requests]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [BEDB]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Capacity_model_0910]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Continuing_care]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [CRX_et]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [CRX_py]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Data_Validation]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Data_Warehouse_2]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Dental]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [ePACT]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [exceptional_treatments]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [JSNA]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Metrics]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [NSTS]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Primary_Care]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Public_health]
GO
DBCC CHECKDB WITH NO_INFOMSGS
Check Database Integrity (CHP-S-DW-001)
Check Database integrity on Local server connection
Databases: Adhoc_Requests,BEDB,Capacity_model_0910,Continuing_care,CRX_et,CRX_py,Data_Validation,Data_Warehouse_2,Dental,ePACT,exceptional_treatments,JSNA,Metrics,NSTS,Primary_Care,Public_health
Include indexes
Task start: 2009-09-09T22:00:03.
Task end: 2009-09-09T22:00:30.
Failed:(-1073548784) Executing the query "DBCC CHECKDB WITH NO_INFOMSGS
" failed with the following error: "There is insufficient system memory to run this query.
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Command:USE [Adhoc_Requests]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [BEDB]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Capacity_model_0910]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Continuing_care]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [CRX_et]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [CRX_py]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Data_Validation]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Data_Warehouse_2]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Dental]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [ePACT]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [exceptional_treatments]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [JSNA]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Metrics]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [NSTS]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Primary_Care]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Public_health]
GO
DBCC CHECKDB WITH NO_INFOMSGS
Shrink Database (CHP-S-DW-001)
Shrink Database on Local server connection
Databases: Adhoc_Requests,BEDB,Capacity_model_0910,Continuing_care,CRX_et,CRX_py,Data_Validation,Data_Warehouse_2,Dental,ePACT,exceptional_treatments,JSNA,Metrics,NSTS,Primary_Care,Public_health
Limit: 50 MB
Free space: 10 %
Task start: 2009-09-09T22:01:59.
Task end: 2009-09-09T22:02:57.
Success
Command:USE [Capacity_model_0910]
GO
DBCC SHRINKDATABASE(N''Capacity_model_0910'', 10, TRUNCATEONLY)
GO
USE [CRX_py]
GO
DBCC SHRINKDATABASE(N''CRX_py'', 10, TRUNCATEONLY)
GO
USE [Data_Validation]
GO
DBCC SHRINKDATABASE(N''Data_Validation'', 10, TRUNCATEONLY)
GO
USE [Data_Warehouse_2]
GO
DBCC SHRINKDATABASE(N''Data_Warehouse_2'', 10, TRUNCATEONLY)
GO
USE [ePACT]
GO
DBCC SHRINKDATABASE(N''ePACT'', 10, TRUNCATEONLY)
GO
USE [NSTS]
GO
DBCC SHRINKDATABASE(N''NSTS'', 10, TRUNCATEONLY)
GO
USE [Public_health]
GO
DBCC SHRINKDATABASE(N''Public_health'', 10, TRUNCATEONLY)
Check Database Integrity (CHP-S-DW-001)
Check Database integrity on Local server connection
Databases: Adhoc_Requests,BEDB,Capacity_model_0910,Continuing_care,CRX_et,CRX_py,Data_Validation,Data_Warehouse_2,Dental,ePACT,exceptional_treatments,JSNA,Metrics,NSTS,Primary_Care,Public_health
Include indexes
Task start: 2009-09-09T22:00:03.
Task end: 2009-09-09T22:00:36.
Failed:(-1073548784) Executing the query "DBCC CHECKDB WITH NO_INFOMSGS
" failed with the following error: "There is insufficient system memory to run this query.
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Command:USE [Adhoc_Requests]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [BEDB]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Capacity_model_0910]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Continuing_care]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [CRX_et]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [CRX_py]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Data_Validation]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Data_Warehouse_2]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Dental]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [ePACT]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [exceptional_treatments]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [JSNA]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Metrics]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [NSTS]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Primary_Care]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Public_health]
GO
DBCC CHECKDB WITH NO_INFOMSGS
Back Up Database (Full) (CHP-S-DW-001)
Backup Database on Local server connection
Databases: Adhoc_Requests,BEDB,Capacity_model_0910,Continuing_care,CRX_et,CRX_py,Data_Validation,Data_Warehouse_2,Dental,ePACT,exceptional_treatments,JSNA,Metrics,NSTS,Primary_Care,Public_health
Type: Full
Append existing
Task start: 2009-09-09T22:03:03.
Task end: 2009-09-09T23:12:04.
Failed:(-1073548784) Executing the query "BACKUP DATABASE [JSNA] TO DISK = N'D:\\File Share\\SQL Server Back Up\\Databases\\JSNA_backup_200909092203.bak' WITH NOFORMAT, NOINIT, NAME = N'JSNA_backup_20090909220303', SKIP, REWIND, NOUNLOAD, STATS = 10
" failed with the following error: "Insufficient resources to create UMS scheduler.
BACKUP DATABASE is terminating abnormally.
10 percent processed.
20 percent processed.
30 percent processed.
40 percent processed.
50 percent processed.
60 percent processed.
70 percent processed.
80 percent processed.
90 percent processed.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Command:BACKUP DATABASE [Adhoc_Requests] TO DISK = N''D:\File Share\SQL Server Back Up\Databases\Adhoc_Requests_backup_200909092203.bak'' WITH NOFORMAT, NOINIT, NAME = N''Adhoc_Requests_backup_20090909220302'', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N''Adhoc_Requests'' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N''Adhoc_Requests'' )
if @backupSetId is null begin raiserror(N''Verify failed. Backup information for database ''''Adhoc_Requests'''' not found.'', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N''D:\File Share\SQL Server Back Up\Databases\Adhoc_Requests_backup_200909092203.bak'' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
GO
BACKUP DATABASE [BEDB] TO DISK = N''D:\File Share\SQL Server Back Up\Databases\BEDB_backup_200909092203.bak'' WITH NOFORMAT, NOINIT, NAME = N''BEDB_backup_20090909220302'', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N''BEDB'' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N''BEDB'' )
if @backupSetId is null begin raiserror(N''Verify failed. Backup information for database ''''BEDB'''' not found.'', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N''D:\File Share\SQL Server Back Up\Databases\BEDB_backup_200909092203.bak'' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
GO
BACKUP DATABASE [Capacity_model_0910] TO DISK = N''D:\File Share\SQL Server Back Up\Databases\Capacity_model_0910_backup_200909092203.bak'' WITH NOFORMAT, NOINIT, NAME = N''Capacity_model_0910_backup_20090909220302'', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N''Capacity_model_0910'' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N''Capacity_model_0910'' )
if @backupSetId is null begin raiserror(N''Verify failed. Backup information for database ''''Capacity_model_0910'''' not found.'', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N''D:\File Share\SQL Server Back Up\Databases\Capacity_model_0910_backup_200909092203.bak'' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
GO
BACKUP DATABASE [Continuing_care] TO DISK = N''D:\File Share\SQL Server Back Up\Databases\Continuing_care_backup_200909092203.bak'' WITH NOFORMAT, NOINIT, NAME = N''Continuing_care_backup_20090909220302'', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N''Continuing_care'' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N''Continuing_care'' )
if @backupSetId is null begin raiserror(N''Verify failed. Backup information for database ''''Continuing_care'''' not found.'', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N''D:\File Share\SQL Server Back Up\Databases\Continuing_care_backup_200909092203.bak'' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
GO
BACKUP DATABASE [CRX_et] TO DISK = N''D:\File Share\SQL Server Back Up\Databases\CRX_et_backup_200909092203.bak'' WITH NOFORMAT, NOINIT, NAME = N''CRX_et_backup_20090909220303'', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N''CRX_et'' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N''CRX_et'' )
if @backupSetId is null begin raiserror(N''Verify failed. Backup information for database ''''CRX_et'''' not found.'', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N''D:\File Share\SQL Server Back Up\Databases\CRX_et_backup_200909092203.bak'' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
GO
BACKUP DATABASE [CRX_py] TO DISK = N''D:\File Share\SQL Server Back Up\Databases\CRX_py_backup_200909092203.bak'' WITH NOFORMAT, NOINIT, NAME = N''CRX_py_backup_20090909220303'', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N''CRX_py'' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N''CRX_py'' )
if @backupSetId is null begin raiserror(N''Verify failed. Backup information for database ''''CRX_py'''' not found.'', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N''D:\File Share\SQL Server Back Up\Databases\CRX_py_backup_200909092203.bak'' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
GO
BACKUP DATABASE [Data_Validation] TO DISK = N''D:\File Share\SQL Server Back Up\Databases\Data_Validation_backup_200909092203.bak'' WITH NOFORMAT, NOINIT, NAME = N''Data_Validation_backup_20090909220303'', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N''Data_Validation'' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N''Data_Validation'' )
if @backupSetId is null begin raiserror(N''Verify failed. Backup information for database ''''Data_Validation'''' not found.'', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N''D:\File Share\SQL Server Back Up\Databases\Data_Validation_backup_200909092203.bak'' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
GO
BACKUP DATABASE [Data_Warehouse_2] TO DISK = N''D:\File Share\SQL Server Back Up\Databases\Data_Warehouse_2_backup_200909092203.bak'' WITH NOFORMAT, NOINIT, NAME = N''Data_Warehouse_2_backup_20090909220303'', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N''Data_Warehouse_2'' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N''Data_Warehouse_2'' )
if @backupSetId is null begin raiserror(N''Verify failed. Backup information for database ''''Data_Warehouse_2'''' not found.'', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N''D:\File Share\SQL Server Back Up\Databases\Data_Warehouse_2_backup_200909092203.bak'' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
GO
BACKUP DATABASE [Dental] TO DISK = N''D:\File Share\SQL Server Back Up\Databases\Dental_backup_200909092203.bak'' WITH NOFORMAT, NOINIT, NAME = N''Dental_backup_20090909220303'', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N''Dental'' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N''Dental'' )
if @backupSetId is null begin raiserror(N''Verify failed. Backup information for database ''''Dental'''' not found.'', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N''D:\File Share\SQL Server Back Up\Databases\Dental_backup_200909092203.bak'' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
GO
BACKUP DATABASE [ePACT] TO DISK = N''D:\File Share\SQL Server Back Up\Databases\ePACT_backup_200909092203.bak'' WITH NOFORMAT, NOINIT, NAME = N''ePACT_backup_20090909220303'', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N''ePACT'' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N''ePACT'' )
if @backupSetId is null begin raiserror(N''Verify failed. Backup information for database ''''ePACT'''' not found.'', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N''D:\File Share\SQL Server Back Up\Databases\ePACT_backup_200909092203.bak'' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
GO
BACKUP DATABASE [exceptional_treatments] TO DISK = N''D:\File Share\SQL Server Back Up\Databases\exceptional_treatments_backup_200909092203.bak'' WITH NOFORMAT, NOINIT, NAME = N''exceptional_treatments_backup_20090909220303'', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N''exceptional_treatments'' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N''exceptional_treatments'' )
if @backupSetId is null begin raiserror(N''Verify failed. Backup information for database ''''exceptional_treatments'''' not found.'', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N''D:\File Share\SQL Server Back Up\Databases\exceptional_treatments_backup_200909092203.bak'' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
GO
BACKUP DATABASE [JSNA] TO DISK = N''D:\File Share\SQL Server Back Up\Databases\JSNA_backup_200909092203.bak'' WITH NOFORMAT, NOINIT, NAME = N''JSNA_backup_20090909220303'', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N''JSNA'' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N''JSNA'' )
if @backupSetId is null begin raiserror(N''Verify failed. Backup information for database ''''JSNA'''' not found.'', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N''D:\File Share\SQL Server Back Up\Databases\JSNA_backup_200909092203.bak'' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
GO
BACKUP DATABASE [Metrics] TO DISK = N''D:\File Share\SQL Server Back Up\Databases\Metrics_backup_200909092203.bak'' WITH NOFORMAT, NOINIT, NAME = N''Metrics_backup_20090909220303'', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N''Metrics'' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N''Metrics'' )
if @backupSetId is null begin raiserror(N''Verify failed. Backup information for database ''''Metrics'''' not found.'', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N''D:\File Share\SQL Server Back Up\Databases\Metrics_backup_200909092203.bak'' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
GO
BACKUP DATABASE [NSTS] TO DISK = N''D:\File Share\SQL Server Back Up\Databases\NSTS_backup_200909092203.bak'' WITH NOFORMAT, NOINIT, NAME = N''NSTS_backup_20090909220303'', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N''NSTS'' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N''NSTS'' )
if @backupSetId is null begin raiserror(N''Verify failed. Backup information for database ''''NSTS'''' not found.'', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N''D:\File Share\SQL Server Back Up\Databases\NSTS_backup_200909092203.bak'' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
GO
BACKUP DATABASE [Primary_Care] TO DISK = N''D:\File Share\SQL Server Back Up\Databases\Primary_Care_backup_200909092203.bak'' WITH NOFORMAT, NOINIT, NAME = N''Primary_Care_backup_20090909220303'', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N''Primary_Care'' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N''Primary_Care'' )
if @backupSetId is null begin raiserror(N''Verify failed. Backup information for database ''''Primary_Care'''' not found.'', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N''D:\File Share\SQL Server Back Up\Databases\Primary_Care_backup_200909092203.bak'' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
GO
BACKUP DATABASE [Public_health] TO DISK = N''D:\File Share\SQL Server Back Up\Databases\Public_health_backup_200909092203.bak'' WITH NOFORMAT, NOINIT, NAME = N''Public_health_backup_20090909220303'', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N''Public_health'' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N''Public_health'' )
if @backupSetId is null begin raiserror(N''Verify failed. Backup information for database ''''Public_health'''' not found.'', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N''D:\File Share\SQL Server Back Up\Databases\Public_health_backup_200909092203.bak'' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
Check Database Integrity (CHP-S-DW-001)
Check Database integrity on Local server connection
Databases: Adhoc_Requests,BEDB,Capacity_model_0910,Continuing_care,CRX_et,CRX_py,Data_Validation,Data_Warehouse_2,Dental,ePACT,exceptional_treatments,JSNA,Metrics,NSTS,Primary_Care,Public_health
Include indexes
Task start: 2009-09-09T22:00:03.
Task end: 2009-09-09T22:00:42.
Failed:(-1073548784) Executing the query "DBCC CHECKDB WITH NO_INFOMSGS
" failed with the following error: "There is insufficient system memory to run this query.
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Command:USE [Adhoc_Requests]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [BEDB]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Capacity_model_0910]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Continuing_care]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [CRX_et]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [CRX_py]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Data_Validation]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Data_Warehouse_2]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Dental]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [ePACT]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [exceptional_treatments]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [JSNA]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Metrics]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [NSTS]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Primary_Care]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Public_health]
GO
DBCC CHECKDB WITH NO_INFOMSGS
Maintenance Cleanup Task (CHP-S-DW-001)
Maintenance Cleanup on Local server connection
Cleanup Database Backup files
Age: Older than 46 Hours
Task start: 2009-09-09T22:02:57.
Task end: 2009-09-09T22:03:02.
Success
Command:EXECUTE master.dbo.xp_delete_file 0,N''D:\File Share\SQL Server Back Up\Databases'',N''bak'',N''2009-09-08T00:02:57''
Check Database Integrity (CHP-S-DW-001)
Check Database integrity on Local server connection
Databases: Adhoc_Requests,BEDB,Capacity_model_0910,Continuing_care,CRX_et,CRX_py,Data_Validation,Data_Warehouse_2,Dental,ePACT,exceptional_treatments,JSNA,Metrics,NSTS,Primary_Care,Public_health
Include indexes
Task start: 2009-09-09T22:00:03.
Task end: 2009-09-09T22:00:48.
Failed:(-1073548784) Executing the query "DBCC CHECKDB WITH NO_INFOMSGS
" failed with the following error: "There is insufficient system memory to run this query.
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Command:USE [Adhoc_Requests]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [BEDB]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Capacity_model_0910]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Continuing_care]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [CRX_et]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [CRX_py]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Data_Validation]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Data_Warehouse_2]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Dental]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [ePACT]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [exceptional_treatments]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [JSNA]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Metrics]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [NSTS]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Primary_Care]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Public_health]
GO
DBCC CHECKDB WITH NO_INFOMSGS
Back Up Database (Full) (CHP-S-DW-001)
Backup Database on Local server connection
Databases: Adhoc_Requests,BEDB,Capacity_model_0910,Continuing_care,CRX_et,CRX_py,Data_Validation,Data_Warehouse_2,Dental,ePACT,exceptional_treatments,JSNA,Metrics,NSTS,Primary_Care,Public_health
Type: Full
Append existing
Task start: 2009-09-09T22:03:03.
Task end: 2009-09-09T23:12:04.
Failed:(-1073548784) Executing the query "declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N'JSNA' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N'JSNA' )
if @backupSetId is null begin raiserror(N'Verify failed. Backup information for database ''JSNA'' not found.', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N'D:\\File Share\\SQL Server Back Up\\Databases\\JSNA_backup_200909092203.bak' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
" failed with the following error: "Cannot open backup device 'D:\\File Share\\SQL Server Back Up\\Databases\\JSNA_backup_200909092203.bak'. Operating system error 2(error not found).
VERIFY DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Command:BACKUP DATABASE [Adhoc_Requests] TO DISK = N''D:\File Share\SQL Server Back Up\Databases\Adhoc_Requests_backup_200909092203.bak'' WITH NOFORMAT, NOINIT, NAME = N''Adhoc_Requests_backup_20090909220302'', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N''Adhoc_Requests'' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N''Adhoc_Requests'' )
if @backupSetId is null begin raiserror(N''Verify failed. Backup information for database ''''Adhoc_Requests'''' not found.'', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N''D:\File Share\SQL Server Back Up\Databases\Adhoc_Requests_backup_200909092203.bak'' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
GO
BACKUP DATABASE [BEDB] TO DISK = N''D:\File Share\SQL Server Back Up\Databases\BEDB_backup_200909092203.bak'' WITH NOFORMAT, NOINIT, NAME = N''BEDB_backup_20090909220302'', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N''BEDB'' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N''BEDB'' )
if @backupSetId is null begin raiserror(N''Verify failed. Backup information for database ''''BEDB'''' not found.'', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N''D:\File Share\SQL Server Back Up\Databases\BEDB_backup_200909092203.bak'' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
GO
BACKUP DATABASE [Capacity_model_0910] TO DISK = N''D:\File Share\SQL Server Back Up\Databases\Capacity_model_0910_backup_200909092203.bak'' WITH NOFORMAT, NOINIT, NAME = N''Capacity_model_0910_backup_20090909220302'', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N''Capacity_model_0910'' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N''Capacity_model_0910'' )
if @backupSetId is null begin raiserror(N''Verify failed. Backup information for database ''''Capacity_model_0910'''' not found.'', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N''D:\File Share\SQL Server Back Up\Databases\Capacity_model_0910_backup_200909092203.bak'' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
GO
BACKUP DATABASE [Continuing_care] TO DISK = N''D:\File Share\SQL Server Back Up\Databases\Continuing_care_backup_200909092203.bak'' WITH NOFORMAT, NOINIT, NAME = N''Continuing_care_backup_20090909220302'', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N''Continuing_care'' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N''Continuing_care'' )
if @backupSetId is null begin raiserror(N''Verify failed. Backup information for database ''''Continuing_care'''' not found.'', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N''D:\File Share\SQL Server Back Up\Databases\Continuing_care_backup_200909092203.bak'' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
GO
BACKUP DATABASE [CRX_et] TO DISK = N''D:\File Share\SQL Server Back Up\Databases\CRX_et_backup_200909092203.bak'' WITH NOFORMAT, NOINIT, NAME = N''CRX_et_backup_20090909220303'', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N''CRX_et'' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N''CRX_et'' )
if @backupSetId is null begin raiserror(N''Verify failed. Backup information for database ''''CRX_et'''' not found.'', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N''D:\File Share\SQL Server Back Up\Databases\CRX_et_backup_200909092203.bak'' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
GO
BACKUP DATABASE [CRX_py] TO DISK = N''D:\File Share\SQL Server Back Up\Databases\CRX_py_backup_200909092203.bak'' WITH NOFORMAT, NOINIT, NAME = N''CRX_py_backup_20090909220303'', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N''CRX_py'' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N''CRX_py'' )
if @backupSetId is null begin raiserror(N''Verify failed. Backup information for database ''''CRX_py'''' not found.'', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N''D:\File Share\SQL Server Back Up\Databases\CRX_py_backup_200909092203.bak'' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
GO
BACKUP DATABASE [Data_Validation] TO DISK = N''D:\File Share\SQL Server Back Up\Databases\Data_Validation_backup_200909092203.bak'' WITH NOFORMAT, NOINIT, NAME = N''Data_Validation_backup_20090909220303'', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N''Data_Validation'' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N''Data_Validation'' )
if @backupSetId is null begin raiserror(N''Verify failed. Backup information for database ''''Data_Validation'''' not found.'', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N''D:\File Share\SQL Server Back Up\Databases\Data_Validation_backup_200909092203.bak'' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
GO
BACKUP DATABASE [Data_Warehouse_2] TO DISK = N''D:\File Share\SQL Server Back Up\Databases\Data_Warehouse_2_backup_200909092203.bak'' WITH NOFORMAT, NOINIT, NAME = N''Data_Warehouse_2_backup_20090909220303'', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N''Data_Warehouse_2'' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N''Data_Warehouse_2'' )
if @backupSetId is null begin raiserror(N''Verify failed. Backup information for database ''''Data_Warehouse_2'''' not found.'', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N''D:\File Share\SQL Server Back Up\Databases\Data_Warehouse_2_backup_200909092203.bak'' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
GO
BACKUP DATABASE [Dental] TO DISK = N''D:\File Share\SQL Server Back Up\Databases\Dental_backup_200909092203.bak'' WITH NOFORMAT, NOINIT, NAME = N''Dental_backup_20090909220303'', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N''Dental'' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N''Dental'' )
if @backupSetId is null begin raiserror(N''Verify failed. Backup information for database ''''Dental'''' not found.'', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N''D:\File Share\SQL Server Back Up\Databases\Dental_backup_200909092203.bak'' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
GO
BACKUP DATABASE [ePACT] TO DISK = N''D:\File Share\SQL Server Back Up\Databases\ePACT_backup_200909092203.bak'' WITH NOFORMAT, NOINIT, NAME = N''ePACT_backup_20090909220303'', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N''ePACT'' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N''ePACT'' )
if @backupSetId is null begin raiserror(N''Verify failed. Backup information for database ''''ePACT'''' not found.'', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N''D:\File Share\SQL Server Back Up\Databases\ePACT_backup_200909092203.bak'' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
GO
BACKUP DATABASE [exceptional_treatments] TO DISK = N''D:\File Share\SQL Server Back Up\Databases\exceptional_treatments_backup_200909092203.bak'' WITH NOFORMAT, NOINIT, NAME = N''exceptional_treatments_backup_20090909220303'', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N''exceptional_treatments'' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N''exceptional_treatments'' )
if @backupSetId is null begin raiserror(N''Verify failed. Backup information for database ''''exceptional_treatments'''' not found.'', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N''D:\File Share\SQL Server Back Up\Databases\exceptional_treatments_backup_200909092203.bak'' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
GO
BACKUP DATABASE [JSNA] TO DISK = N''D:\File Share\SQL Server Back Up\Databases\JSNA_backup_200909092203.bak'' WITH NOFORMAT, NOINIT, NAME = N''JSNA_backup_20090909220303'', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N''JSNA'' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N''JSNA'' )
if @backupSetId is null begin raiserror(N''Verify failed. Backup information for database ''''JSNA'''' not found.'', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N''D:\File Share\SQL Server Back Up\Databases\JSNA_backup_200909092203.bak'' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
GO
BACKUP DATABASE [Metrics] TO DISK = N''D:\File Share\SQL Server Back Up\Databases\Metrics_backup_200909092203.bak'' WITH NOFORMAT, NOINIT, NAME = N''Metrics_backup_20090909220303'', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N''Metrics'' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N''Metrics'' )
if @backupSetId is null begin raiserror(N''Verify failed. Backup information for database ''''Metrics'''' not found.'', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N''D:\File Share\SQL Server Back Up\Databases\Metrics_backup_200909092203.bak'' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
GO
BACKUP DATABASE [NSTS] TO DISK = N''D:\File Share\SQL Server Back Up\Databases\NSTS_backup_200909092203.bak'' WITH NOFORMAT, NOINIT, NAME = N''NSTS_backup_20090909220303'', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N''NSTS'' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N''NSTS'' )
if @backupSetId is null begin raiserror(N''Verify failed. Backup information for database ''''NSTS'''' not found.'', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N''D:\File Share\SQL Server Back Up\Databases\NSTS_backup_200909092203.bak'' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
GO
BACKUP DATABASE [Primary_Care] TO DISK = N''D:\File Share\SQL Server Back Up\Databases\Primary_Care_backup_200909092203.bak'' WITH NOFORMAT, NOINIT, NAME = N''Primary_Care_backup_20090909220303'', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N''Primary_Care'' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N''Primary_Care'' )
if @backupSetId is null begin raiserror(N''Verify failed. Backup information for database ''''Primary_Care'''' not found.'', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N''D:\File Share\SQL Server Back Up\Databases\Primary_Care_backup_200909092203.bak'' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
GO
BACKUP DATABASE [Public_health] TO DISK = N''D:\File Share\SQL Server Back Up\Databases\Public_health_backup_200909092203.bak'' WITH NOFORMAT, NOINIT, NAME = N''Public_health_backup_20090909220303'', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N''Public_health'' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N''Public_health'' )
if @backupSetId is null begin raiserror(N''Verify failed. Backup information for database ''''Public_health'''' not found.'', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N''D:\File Share\SQL Server Back Up\Databases\Public_health_backup_200909092203.bak'' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
Check Database Integrity (CHP-S-DW-001)
Check Database integrity on Local server connection
Databases: Adhoc_Requests,BEDB,Capacity_model_0910,Continuing_care,CRX_et,CRX_py,Data_Validation,Data_Warehouse_2,Dental,ePACT,exceptional_treatments,JSNA,Metrics,NSTS,Primary_Care,Public_health
Include indexes
Task start: 2009-09-09T22:00:03.
Task end: 2009-09-09T22:00:54.
Failed:(-1073548784) Executing the query "DBCC CHECKDB WITH NO_INFOMSGS
" failed with the following error: "There is insufficient system memory to run this query.
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Command:USE [Adhoc_Requests]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [BEDB]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Capacity_model_0910]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Continuing_care]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [CRX_et]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [CRX_py]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Data_Validation]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Data_Warehouse_2]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Dental]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [ePACT]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [exceptional_treatments]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [JSNA]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Metrics]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [NSTS]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Primary_Care]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Public_health]
GO
DBCC CHECKDB WITH NO_INFOMSGS
Check Database Integrity (CHP-S-DW-001)
Check Database integrity on Local server connection
Databases: Adhoc_Requests,BEDB,Capacity_model_0910,Continuing_care,CRX_et,CRX_py,Data_Validation,Data_Warehouse_2,Dental,ePACT,exceptional_treatments,JSNA,Metrics,NSTS,Primary_Care,Public_health
Include indexes
Task start: 2009-09-09T22:00:03.
Task end: 2009-09-09T22:01:00.
Failed:(-1073548784) Executing the query "DBCC CHECKDB WITH NO_INFOMSGS
" failed with the following error: "There is insufficient system memory to run this query.
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Command:USE [Adhoc_Requests]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [BEDB]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Capacity_model_0910]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Continuing_care]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [CRX_et]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [CRX_py]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Data_Validation]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Data_Warehouse_2]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Dental]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [ePACT]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [exceptional_treatments]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [JSNA]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Metrics]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [NSTS]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Primary_Care]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Public_health]
GO
DBCC CHECKDB WITH NO_INFOMSGS
Check Database Integrity (CHP-S-DW-001)
Check Database integrity on Local server connection
Databases: Adhoc_Requests,BEDB,Capacity_model_0910,Continuing_care,CRX_et,CRX_py,Data_Validation,Data_Warehouse_2,Dental,ePACT,exceptional_treatments,JSNA,Metrics,NSTS,Primary_Care,Public_health
Include indexes
Task start: 2009-09-09T22:00:03.
Task end: 2009-09-09T22:01:06.
Failed:(-1073548784) Executing the query "DBCC CHECKDB WITH NO_INFOMSGS
" failed with the following error: "There is insufficient system memory to run this query.
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Command:USE [Adhoc_Requests]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [BEDB]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Capacity_model_0910]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Continuing_care]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [CRX_et]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [CRX_py]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Data_Validation]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Data_Warehouse_2]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Dental]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [ePACT]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [exceptional_treatments]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [JSNA]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Metrics]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [NSTS]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Primary_Care]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Public_health]
GO
DBCC CHECKDB WITH NO_INFOMSGS
Check Database Integrity (CHP-S-DW-001)
Check Database integrity on Local server connection
Databases: Adhoc_Requests,BEDB,Capacity_model_0910,Continuing_care,CRX_et,CRX_py,Data_Validation,Data_Warehouse_2,Dental,ePACT,exceptional_treatments,JSNA,Metrics,NSTS,Primary_Care,Public_health
Include indexes
Task start: 2009-09-09T22:00:03.
Task end: 2009-09-09T22:01:12.
Failed:(-1073548784) Executing the query "DBCC CHECKDB WITH NO_INFOMSGS
" failed with the following error: "There is insufficient system memory to run this query.
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Command:USE [Adhoc_Requests]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [BEDB]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Capacity_model_0910]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Continuing_care]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [CRX_et]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [CRX_py]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Data_Validation]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Data_Warehouse_2]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Dental]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [ePACT]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [exceptional_treatments]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [JSNA]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Metrics]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [NSTS]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Primary_Care]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Public_health]
GO
DBCC CHECKDB WITH NO_INFOMSGS
Check Database Integrity (CHP-S-DW-001)
Check Database integrity on Local server connection
Databases: Adhoc_Requests,BEDB,Capacity_model_0910,Continuing_care,CRX_et,CRX_py,Data_Validation,Data_Warehouse_2,Dental,ePACT,exceptional_treatments,JSNA,Metrics,NSTS,Primary_Care,Public_health
Include indexes
Task start: 2009-09-09T22:00:03.
Task end: 2009-09-09T22:01:18.
Failed:(-1073548784) Executing the query "DBCC CHECKDB WITH NO_INFOMSGS
" failed with the following error: "There is insufficient system memory to run this query.
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Command:USE [Adhoc_Requests]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [BEDB]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Capacity_model_0910]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Continuing_care]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [CRX_et]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [CRX_py]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Data_Validation]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Data_Warehouse_2]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Dental]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [ePACT]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [exceptional_treatments]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [JSNA]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Metrics]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [NSTS]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Primary_Care]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Public_health]
GO
DBCC CHECKDB WITH NO_INFOMSGS
Check Database Integrity (CHP-S-DW-001)
Check Database integrity on Local server connection
Databases: Adhoc_Requests,BEDB,Capacity_model_0910,Continuing_care,CRX_et,CRX_py,Data_Validation,Data_Warehouse_2,Dental,ePACT,exceptional_treatments,JSNA,Metrics,NSTS,Primary_Care,Public_health
Include indexes
Task start: 2009-09-09T22:00:03.
Task end: 2009-09-09T22:01:23.
Failed:(-1073548784) Executing the query "DBCC CHECKDB WITH NO_INFOMSGS
" failed with the following error: "There is insufficient system memory to run this query.
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Command:USE [Adhoc_Requests]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [BEDB]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Capacity_model_0910]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Continuing_care]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [CRX_et]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [CRX_py]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Data_Validation]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Data_Warehouse_2]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Dental]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [ePACT]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [exceptional_treatments]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [JSNA]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Metrics]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [NSTS]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Primary_Care]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Public_health]
GO
DBCC CHECKDB WITH NO_INFOMSGS
Check Database Integrity (CHP-S-DW-001)
Check Database integrity on Local server connection
Databases: Adhoc_Requests,BEDB,Capacity_model_0910,Continuing_care,CRX_et,CRX_py,Data_Validation,Data_Warehouse_2,Dental,ePACT,exceptional_treatments,JSNA,Metrics,NSTS,Primary_Care,Public_health
Include indexes
Task start: 2009-09-09T22:00:03.
Task end: 2009-09-09T22:01:29.
Failed:(-1073548784) Executing the query "DBCC CHECKDB WITH NO_INFOMSGS
" failed with the following error: "There is insufficient system memory to run this query.
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Command:USE [Adhoc_Requests]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [BEDB]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Capacity_model_0910]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Continuing_care]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [CRX_et]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [CRX_py]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Data_Validation]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Data_Warehouse_2]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Dental]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [ePACT]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [exceptional_treatments]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [JSNA]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Metrics]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [NSTS]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Primary_Care]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Public_health]
GO
DBCC CHECKDB WITH NO_INFOMSGS
Check Database Integrity (CHP-S-DW-001)
Check Database integrity on Local server connection
Databases: Adhoc_Requests,BEDB,Capacity_model_0910,Continuing_care,CRX_et,CRX_py,Data_Validation,Data_Warehouse_2,Dental,ePACT,exceptional_treatments,JSNA,Metrics,NSTS,Primary_Care,Public_health
Include indexes
Task start: 2009-09-09T22:00:03.
Task end: 2009-09-09T22:01:35.
Failed:(-1073548784) Executing the query "DBCC CHECKDB WITH NO_INFOMSGS
" failed with the following error: "There is insufficient system memory to run this query.
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Command:USE [Adhoc_Requests]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [BEDB]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Capacity_model_0910]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Continuing_care]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [CRX_et]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [CRX_py]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Data_Validation]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Data_Warehouse_2]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Dental]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [ePACT]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [exceptional_treatments]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [JSNA]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Metrics]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [NSTS]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Primary_Care]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Public_health]
GO
DBCC CHECKDB WITH NO_INFOMSGS
Check Database Integrity (CHP-S-DW-001)
Check Database integrity on Local server connection
Databases: Adhoc_Requests,BEDB,Capacity_model_0910,Continuing_care,CRX_et,CRX_py,Data_Validation,Data_Warehouse_2,Dental,ePACT,exceptional_treatments,JSNA,Metrics,NSTS,Primary_Care,Public_health
Include indexes
Task start: 2009-09-09T22:00:03.
Task end: 2009-09-09T22:01:41.
Failed:(-1073548784) Executing the query "DBCC CHECKDB WITH NO_INFOMSGS
" failed with the following error: "There is insufficient system memory to run this query.
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Command:USE [Adhoc_Requests]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [BEDB]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Capacity_model_0910]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Continuing_care]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [CRX_et]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [CRX_py]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Data_Validation]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Data_Warehouse_2]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Dental]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [ePACT]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [exceptional_treatments]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [JSNA]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Metrics]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [NSTS]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Primary_Care]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Public_health]
GO
DBCC CHECKDB WITH NO_INFOMSGS
Check Database Integrity (CHP-S-DW-001)
Check Database integrity on Local server connection
Databases: Adhoc_Requests,BEDB,Capacity_model_0910,Continuing_care,CRX_et,CRX_py,Data_Validation,Data_Warehouse_2,Dental,ePACT,exceptional_treatments,JSNA,Metrics,NSTS,Primary_Care,Public_health
Include indexes
Task start: 2009-09-09T22:00:03.
Task end: 2009-09-09T22:01:46.
Failed:(-1073548784) Executing the query "DBCC CHECKDB WITH NO_INFOMSGS
" failed with the following error: "There is insufficient system memory to run this query.
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Command:USE [Adhoc_Requests]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [BEDB]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Capacity_model_0910]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Continuing_care]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [CRX_et]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [CRX_py]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Data_Validation]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Data_Warehouse_2]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Dental]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [ePACT]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [exceptional_treatments]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [JSNA]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Metrics]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [NSTS]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Primary_Care]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [Public_health]
GO
DBCC CHECKDB WITH NO_INFOMSGS
I have never come acrosss this error before so does anyone have advice on how I coulde remedy the situation.
Regards
SAUCE1979
September 10, 2009 at 5:11 am
pheww..
How many errors have you actually got in those logs.
I would suggest that you run a manual dbcc checkdb on those databases and see what it returns now.
I have seen an out of memory error when an index has been corrupted. but you can normally narrow that down to the table and index based on what dbcc checkdb returns. try that first and let us know if that works.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 10, 2009 at 5:56 am
I ran a manual dbcc checkdb and the output is as follows.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (referenced_major_id=1977058079) of row (class=0,object_id=357576312,column_id=0,referenced_major_id=1977058079,referenced_minor_id=0) in sys.sql_dependencies has a matching row (object_id=1977058079) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (referenced_major_id=1977058079) of row (class=0,object_id=485576768,column_id=0,referenced_major_id=1977058079,referenced_minor_id=0) in sys.sql_dependencies has a matching row (object_id=1977058079) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (referenced_major_id=1977058079) of row (class=0,object_id=501576825,column_id=0,referenced_major_id=1977058079,referenced_minor_id=0) in sys.sql_dependencies has a matching row (object_id=1977058079) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (parent_object_id=1977058079) of row (object_id=1993058136) in sys.objects has a matching row (object_id=1977058079) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (parent_object_id=1977058079) of row (object_id=2009058193) in sys.objects has a matching row (object_id=1977058079) in sys.objects (type=S ) that is invalid.
CHECKDB found 0 allocation errors and 5 consistency errors not associated with any single object.
CHECKDB found 0 allocation errors and 5 consistency errors in database 'Adhoc_Requests'.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near 'GO'.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near 'GO'.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near 'GO'.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (referenced_major_id=1977058079) of row (class=0,object_id=98099390,column_id=0,referenced_major_id=1977058079,referenced_minor_id=0) in sys.sql_dependencies has a matching row (object_id=1977058079) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (referenced_major_id=1977058079) of row (class=0,object_id=114099447,column_id=0,referenced_major_id=1977058079,referenced_minor_id=0) in sys.sql_dependencies has a matching row (object_id=1977058079) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (parent_object_id=1977058079) of row (object_id=1993058136) in sys.objects has a matching row (object_id=1977058079) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (parent_object_id=1977058079) of row (object_id=2009058193) in sys.objects has a matching row (object_id=1977058079) in sys.objects (type=S ) that is invalid.
CHECKDB found 0 allocation errors and 4 consistency errors not associated with any single object.
CHECKDB found 0 allocation errors and 4 consistency errors in database 'Data_Validation'.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (referenced_major_id=645577338) of row (class=0,object_id=1445580188,column_id=0,referenced_major_id=645577338,referenced_minor_id=0) in sys.sql_dependencies has a matching row (object_id=645577338) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (referenced_major_id=645577338) of row (class=0,object_id=1573580644,column_id=0,referenced_major_id=645577338,referenced_minor_id=0) in sys.sql_dependencies has a matching row (object_id=645577338) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (referenced_major_id=645577338) of row (class=0,object_id=1589580701,column_id=0,referenced_major_id=645577338,referenced_minor_id=0) in sys.sql_dependencies has a matching row (object_id=645577338) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (parent_object_id=645577338) of row (object_id=661577395) in sys.objects has a matching row (object_id=645577338) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (parent_object_id=645577338) of row (object_id=677577452) in sys.objects has a matching row (object_id=645577338) in sys.objects (type=S ) that is invalid.
CHECKDB found 0 allocation errors and 5 consistency errors not associated with any single object.
CHECKDB found 0 allocation errors and 5 consistency errors in database 'Data_Warehouse_2'.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (referenced_major_id=2057058364) of row (class=0,object_id=5575058,column_id=0,referenced_major_id=2057058364,referenced_minor_id=0) in sys.sql_dependencies has a matching row (object_id=2057058364) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (referenced_major_id=2057058364) of row (class=0,object_id=21575115,column_id=0,referenced_major_id=2057058364,referenced_minor_id=0) in sys.sql_dependencies has a matching row (object_id=2057058364) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (referenced_major_id=2057058364) of row (class=0,object_id=85575343,column_id=0,referenced_major_id=2057058364,referenced_minor_id=0) in sys.sql_dependencies has a matching row (object_id=2057058364) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (referenced_major_id=2057058364) of row (class=0,object_id=101575400,column_id=0,referenced_major_id=2057058364,referenced_minor_id=0) in sys.sql_dependencies has a matching row (object_id=2057058364) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (parent_object_id=2057058364) of row (object_id=2073058421) in sys.objects has a matching row (object_id=2057058364) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (parent_object_id=2057058364) of row (object_id=2089058478) in sys.objects has a matching row (object_id=2057058364) in sys.objects (type=S ) that is invalid.
CHECKDB found 0 allocation errors and 6 consistency errors not associated with any single object.
CHECKDB found 0 allocation errors and 6 consistency errors in database 'Dental'.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (referenced_major_id=1977058079) of row (class=0,object_id=5575058,column_id=0,referenced_major_id=1977058079,referenced_minor_id=0) in sys.sql_dependencies has a matching row (object_id=1977058079) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (referenced_major_id=1977058079) of row (class=0,object_id=21575115,column_id=0,referenced_major_id=1977058079,referenced_minor_id=0) in sys.sql_dependencies has a matching row (object_id=1977058079) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (parent_object_id=1977058079) of row (object_id=1993058136) in sys.objects has a matching row (object_id=1977058079) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (parent_object_id=1977058079) of row (object_id=2009058193) in sys.objects has a matching row (object_id=1977058079) in sys.objects (type=S ) that is invalid.
CHECKDB found 0 allocation errors and 4 consistency errors not associated with any single object.
CHECKDB found 0 allocation errors and 4 consistency errors in database 'Metrics'.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (referenced_major_id=1993058136) of row (class=0,object_id=5575058,column_id=0,referenced_major_id=1993058136,referenced_minor_id=0) in sys.sql_dependencies has a matching row (object_id=1993058136) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (referenced_major_id=1993058136) of row (class=0,object_id=21575115,column_id=0,referenced_major_id=1993058136,referenced_minor_id=0) in sys.sql_dependencies has a matching row (object_id=1993058136) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (referenced_major_id=1993058136) of row (class=0,object_id=37575172,column_id=0,referenced_major_id=1993058136,referenced_minor_id=0) in sys.sql_dependencies has a matching row (object_id=1993058136) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (parent_object_id=1993058136) of row (object_id=2009058193) in sys.objects has a matching row (object_id=1993058136) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (parent_object_id=1993058136) of row (object_id=2025058250) in sys.objects has a matching row (object_id=1993058136) in sys.objects (type=S ) that is invalid.
CHECKDB found 0 allocation errors and 5 consistency errors not associated with any single object.
CHECKDB found 0 allocation errors and 5 consistency errors in database 'NSTS'.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (referenced_major_id=1977058079) of row (class=0,object_id=357576312,column_id=0,referenced_major_id=1977058079,referenced_minor_id=0) in sys.sql_dependencies has a matching row (object_id=1977058079) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (referenced_major_id=1977058079) of row (class=0,object_id=485576768,column_id=0,referenced_major_id=1977058079,referenced_minor_id=0) in sys.sql_dependencies has a matching row (object_id=1977058079) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (referenced_major_id=1977058079) of row (class=0,object_id=501576825,column_id=0,referenced_major_id=1977058079,referenced_minor_id=0) in sys.sql_dependencies has a matching row (object_id=1977058079) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (parent_object_id=1977058079) of row (object_id=1993058136) in sys.objects has a matching row (object_id=1977058079) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (parent_object_id=1977058079) of row (object_id=2009058193) in sys.objects has a matching row (object_id=1977058079) in sys.objects (type=S ) that is invalid.
CHECKDB found 0 allocation errors and 5 consistency errors not associated with any single object.
CHECKDB found 0 allocation errors and 5 consistency errors in database 'Adhoc_Requests'.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near 'GO'.
Msg 2508, Level 16, State 3, Line 1
The In-row data RSVD page count for object "AGG346_1_1", index ID 0, partition ID 2908734947328, alloc unit ID 2908734947328 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.
CHECKDB found 0 allocation errors and 1 consistency errors in table 'AGG346_1_1' (object ID 44383773).
Msg 2508, Level 16, State 3, Line 1
The In-row data RSVD page count for object "AGG389_1_1", index ID 0, partition ID 18918983073792, alloc unit ID 18918983073792 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.
CHECKDB found 0 allocation errors and 1 consistency errors in table 'AGG389_1_1' (object ID 288680772).
CHECKDB found 0 allocation errors and 2 consistency errors in database 'CRX_py'.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (referenced_major_id=1977058079) of row (class=0,object_id=98099390,column_id=0,referenced_major_id=1977058079,referenced_minor_id=0) in sys.sql_dependencies has a matching row (object_id=1977058079) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (referenced_major_id=1977058079) of row (class=0,object_id=114099447,column_id=0,referenced_major_id=1977058079,referenced_minor_id=0) in sys.sql_dependencies has a matching row (object_id=1977058079) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (parent_object_id=1977058079) of row (object_id=1993058136) in sys.objects has a matching row (object_id=1977058079) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (parent_object_id=1977058079) of row (object_id=2009058193) in sys.objects has a matching row (object_id=1977058079) in sys.objects (type=S ) that is invalid.
CHECKDB found 0 allocation errors and 4 consistency errors not associated with any single object.
CHECKDB found 0 allocation errors and 4 consistency errors in database 'Data_Validation'.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (referenced_major_id=645577338) of row (class=0,object_id=1445580188,column_id=0,referenced_major_id=645577338,referenced_minor_id=0) in sys.sql_dependencies has a matching row (object_id=645577338) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (referenced_major_id=645577338) of row (class=0,object_id=1573580644,column_id=0,referenced_major_id=645577338,referenced_minor_id=0) in sys.sql_dependencies has a matching row (object_id=645577338) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (referenced_major_id=645577338) of row (class=0,object_id=1589580701,column_id=0,referenced_major_id=645577338,referenced_minor_id=0) in sys.sql_dependencies has a matching row (object_id=645577338) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (parent_object_id=645577338) of row (object_id=661577395) in sys.objects has a matching row (object_id=645577338) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (parent_object_id=645577338) of row (object_id=677577452) in sys.objects has a matching row (object_id=645577338) in sys.objects (type=S ) that is invalid.
CHECKDB found 0 allocation errors and 5 consistency errors not associated with any single object.
CHECKDB found 0 allocation errors and 5 consistency errors in database 'Data_Warehouse_2'.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (referenced_major_id=2057058364) of row (class=0,object_id=5575058,column_id=0,referenced_major_id=2057058364,referenced_minor_id=0) in sys.sql_dependencies has a matching row (object_id=2057058364) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (referenced_major_id=2057058364) of row (class=0,object_id=21575115,column_id=0,referenced_major_id=2057058364,referenced_minor_id=0) in sys.sql_dependencies has a matching row (object_id=2057058364) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (referenced_major_id=2057058364) of row (class=0,object_id=85575343,column_id=0,referenced_major_id=2057058364,referenced_minor_id=0) in sys.sql_dependencies has a matching row (object_id=2057058364) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (referenced_major_id=2057058364) of row (class=0,object_id=101575400,column_id=0,referenced_major_id=2057058364,referenced_minor_id=0) in sys.sql_dependencies has a matching row (object_id=2057058364) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (parent_object_id=2057058364) of row (object_id=2073058421) in sys.objects has a matching row (object_id=2057058364) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (parent_object_id=2057058364) of row (object_id=2089058478) in sys.objects has a matching row (object_id=2057058364) in sys.objects (type=S ) that is invalid.
CHECKDB found 0 allocation errors and 6 consistency errors not associated with any single object.
CHECKDB found 0 allocation errors and 6 consistency errors in database 'Dental'.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (referenced_major_id=1977058079) of row (class=0,object_id=5575058,column_id=0,referenced_major_id=1977058079,referenced_minor_id=0) in sys.sql_dependencies has a matching row (object_id=1977058079) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (referenced_major_id=1977058079) of row (class=0,object_id=21575115,column_id=0,referenced_major_id=1977058079,referenced_minor_id=0) in sys.sql_dependencies has a matching row (object_id=1977058079) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (parent_object_id=1977058079) of row (object_id=1993058136) in sys.objects has a matching row (object_id=1977058079) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (parent_object_id=1977058079) of row (object_id=2009058193) in sys.objects has a matching row (object_id=1977058079) in sys.objects (type=S ) that is invalid.
CHECKDB found 0 allocation errors and 4 consistency errors not associated with any single object.
CHECKDB found 0 allocation errors and 4 consistency errors in database 'Metrics'.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (referenced_major_id=1993058136) of row (class=0,object_id=5575058,column_id=0,referenced_major_id=1993058136,referenced_minor_id=0) in sys.sql_dependencies has a matching row (object_id=1993058136) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (referenced_major_id=1993058136) of row (class=0,object_id=21575115,column_id=0,referenced_major_id=1993058136,referenced_minor_id=0) in sys.sql_dependencies has a matching row (object_id=1993058136) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (referenced_major_id=1993058136) of row (class=0,object_id=37575172,column_id=0,referenced_major_id=1993058136,referenced_minor_id=0) in sys.sql_dependencies has a matching row (object_id=1993058136) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (parent_object_id=1993058136) of row (object_id=2009058193) in sys.objects has a matching row (object_id=1993058136) in sys.objects (type=S ) that is invalid.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3854, State 1: Attribute (parent_object_id=1993058136) of row (object_id=2025058250) in sys.objects has a matching row (object_id=1993058136) in sys.objects (type=S ) that is invalid.
CHECKDB found 0 allocation errors and 5 consistency errors not associated with any single object.
CHECKDB found 0 allocation errors and 5 consistency errors in database 'NSTS'.
September 10, 2009 at 6:26 am
hmmm, interesting, looks like the checkcatalog part of the dbcc checkdb has reported catalogue dependency errors, against system objects.
Really need someone else to confirm...
but I think using sp_refreshsqlmodule might help, but i would wait to see if anyone posts with a easier solution.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 10, 2009 at 9:45 am
how would I apply the sp_refreshsqlmodule procedure? Whats is the syntax.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply