Specific the backup plan is depending in your business requirement. How much data-loss is acceptable and how much time is allowed to get back online after a disaster. In my opinion the timing and frequency of the DIFF and LOG backups are not in line with each other. I should increase the frequency of the LOG backup to every 10 minutes or so. A full backup during working hours could also be a bit of an overkill.
Also the update of the statistics is probably unnecassary. This will allready be done with the rebuild of the indexes. Are all indexes rebuild?
What is the purpose of the Checkpoint on TempDB?
It looks like your previous DBA has implemented the SQL Maintenence Plan. Allthough this has a very simple implementation, it also has some drawbacks. Take a look at some custom maintenance solutions (like the one from Ola Hallengren http://ola.hallengren.com/)
Thanks for the replies guys! just a couple of questions on the above, would you be able to explain a bit more about why the DIFF and LOG backups should be more inline and to increase the amount of LOG backups, or if you have any links on this it would be great.
As far as I know it uses a Maintenance Plan to Rebuild Tables and Views and the option "Reorganize pages with the default amount of space is selected"
And with the Checkpoint on the TempDB, it has been one of those things that has been there since I took over and as it is working I haven't touched it.
Thanks,