May 23, 2012 at 6:42 am
Date05/23/12 2:00:00 AM
LogJob History (Db_Mtc_2005.Mtc_And_Full_Backups)
Step ID1
ServerPSQL
Job NameDb_Mtc_2005.Mtc_And_Full_Backups
Step NameMtc_And_Full_Backups
Duration00:58:13
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
Executed as user: Wmd\srv-sql. ...rsion 9.00.4035.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 2:00:01 AM Error: 2012-05-23 02:57:53.99 Code: 0x00000000 Source: Full Backup with Free Space Check - All Online Databases Except model & msdb Description: BACKUP DATABASE successfully processed 23243 pages in 7.592 seconds (25.079 MB/sec). End Error Error: 2012-05-23 02:57:54.06 Code: 0x00000000 Source: Full Backup with Free Space Check - All Online Databases Except model & msdb Description: The backup set on file 1 is valid. End Error Error: 2012-05-23 02:57:55.20 Code: 0xC002F210 Source: Full Backup with Free Space Check - All Online Databases Except model & msdb Execute SQL Task Description: Executing the query "set nocount on declare @instance_name varchar(128) , @db_exclude_list varchar(512) , @datestamp varchar(20) , @retain_bkp_set_days int , @bkp_root_path ... The package execution fa... The step failed.
May 23, 2012 at 9:19 am
Do you verify the backup? What other items are in that maint plan sub plan that could cause a failure?
CEWII
May 23, 2012 at 1:32 pm
Db_Mtc_2005.Mtc_And_Full_Backups
the backup drive shows updated exactly when ssis backup and maintenance is scheduled
supposed to do several things
check database is online and is full rec model if not exclude
exclude resource database
check the back up disk space has enough space to house the current backup
and back up if all above is checked ture
thanks for the help
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply