Script Download: CheckBackuptoSingleFile.zip
http://gallery.technet.microsoft.com/scriptcenter/Check-database-backups-a38c64a7

The backup history for SQL Server database indicates that backups are getting appended to existing backup devices. This increases the risk of losing all the backups when the backup device gets damaged. Also the performance of backups and restoring operations might be degraded when several backups are appended to one another on the same backup device that resides on a remote server and accessed over the network. Review the backup history information stored in msdb database and configure your backup scripts or solution to store backups in individual backup devices.

We can use Get-OSCBackupToSingleFile to identify the database backups appended to existing backup devices and then list the affected databases. By default, this script uses Windows Authentication to connect to your SQL Server. If you want to use SQL Server Authentication, just uncomment some code in this script.

image image
image

You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery