Share via

[Script of Aug. 27] Check database backups appended to existing backup devices problems (T-SQL)

  • Article

Script Download: CheckBackuptoSingleFile.zip
https://gallery.technet.microsoft.com/scriptcenter/Check-SQL-Server-database-e88b0cf5

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.

This script can be used to detect the database backups appended to existing backup devices problems.

image image
image

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

Comments