The SQL Backup Helper is a set of Stored Procedures and User Defined Functions, which help you automate the process of creating backup sets, cloning database and creating a history set of database backups when using a SQL Server or SQL Server Express editions.
Works with
The SQL Backup Helper can be installed by using the setup binary (Red Gates SQL packager executable). The binary lets you choose the following:
The SQL Backup Helper can be installed by setting up the database manually and by running the Schema and MasterData scripts.
-- How to use SQL Backup Helper -- Example FULL backup command performing a full backup of all databases, -- excluding master,model,msdb,tempdb databases EXEC USP_BackupDatabase 'FULL', NULL, 'master,model,msdb,tempdb' -- Example FULL backup command performing a FULL backup of all databases -- starting with DEV, excluding master,model,msdb,tempdb databases EXEC USP_BackupDatabase 'FULL', 'DEV%', 'master,model,msdb,tempdb' -- Example for cleaning up history, keeping 3 backup sets, having no maximum age, -- including all databases, excluding master,model,msdb,tempdb databases EXEC USP_CleanUpHistory 3, NULL, NULL, 'master,model,msdb,tempdb' -- Example DIFF backup command performing a differential backup of all databases, -- excluding master,model,msdb,tempdb databases EXEC USP_BackupDatabase 'DIFF', NULL, 'master,model,msdb,tempdb' -- Example TRAN backup command performing a tranaction log backup of all databases, -- excluding master,model,msdb,tempdb databases EXEC USP_BackupDatabase 'TRAN', NULL, 'master,model,msdb,tempdb'
Additional credits go to Markus Heiliger for the initial version of the SQL Backup Helper.