Get your favourite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved in your
SSC briefcase from the favorites tab.
Download now (direct download link)
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.