Thank this author by sharing:
By Mark Cook,
This script can be used to execute your backups if you store your backup scripts on a central location. We do this in order to only maintain one copy of the code. However, we have multiple versions and editions of SQL Server in our environment. I want to use Backup Compression on those servers where it is available. The script will determine if Backup Compression is available and build the BACKUP DATABASE command accordingly. I hope you find it useful.
Auto Backup Script
script for backup files
all backup scripts (full, diff, trans)
This script provides very useful information about database backup and restoration.
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.