Ed Wagner (11/12/2016)
Eirikur Eiriksson (11/12/2016)
To me it looks like a Maintenance Plan related error, strongly suggest to switch to Ola Hallengren's SQL Server Maintenance Solution[/url], much more robust.😎
Question, what if any errors are there in msdb.dbo.sysjobhistory, Windows Event Log or the SQL Server Error Logs?
Eirikur, does Ola's backup script handle SQL 2000?
JrDbaK, welcome to SSC and congratulations on your Jr. DBA position. I'd strongly suggest taking Eirikur's advice on Maintenance Plans - do away with them. Also, check out the Books link along the left side of this site. There are a lot of really good books available to download in PDF to help you learn.
First things first - figure out your backups and make sure they support the business requirements for recovery. Make sure they're viable by doing "practice" restores so the first time you do a restore isn't in an actual emergency with the boss breathing down your neck.
Thank you Ed I will have definitely have a look, I been looking for scripts too at the same time, don't always have time to do practice restores since of the workload that I'm but cheers for the advice
To know where you're heading, you gotta know where you been :alien: