I don't use maintenance plans because of different issues.
I use Backup devices for all sqlserver backups ( 3 devices per database ( Full / Diff / Log ) )
Diff and log backups are incremental.
I haven't had many issues using backup devices. I've been using them in this setup since SQL2000.
Down side is msdb will always report the same filename used with a db backup of a given type.
In any case, your recovery scripts/software will have to examine backup files for their content and see if it matches the database and the needed sequences.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me