Db_Mtc_2005.Mtc_And_Full_Backups shows faill message but the back up is there in the backDrive, how can i stop this?

Question

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 1

Do you verify the backup? What other items are in that maint plan sub plan that could cause a failure?

CEWII

SQL learner22 Default port Points: 1487 More actions · Answer 2

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