kaplan71 (8/25/2014)
Hello --So what you are saying is that if that one backup file goes corrupt or missing you lose the backups for ALL your databases.
That is incorrect.
To be honest, your backups should be run separately and each database backup to its own unique backup file.
Although the Full Backups all done under one Subplan, each database has its own unique backup file.
Also curious if you are using compression for your backups.
I checked the T-SQL commands, and there was no option for compression with any of the backups.
Regarding item 2, this is what you said:
The backups are run under one subplan that backs up every database to a individual bak file.
Based on this it was easy to assume that you are backing up to a single file.