This post is just a quick extension of my earlier post on Automating backups for SQL Server 2008 R2 Express Edition. If you’d rather use Ola Hallengren’s SQL Server Maintenance Solution (and you should!), then follow the steps below to replace the first step listed in my previous post. After that, you can carry on with the rest of that post without any further changes.
- Download Ola’s Maintenance Solution (grab the MaintenanceSolution.sql file)
- Execute MaintenanceSolution.sql. This script creates the stored procedures that you need.
- Go back to my Automating backups for SQL Server 2008 R2 Express Edition post, and replace all code listed in the dailyBackupScript.sql file with the below stored procedure call.dailyBackupScript.sql123456EXECUTE dbo.DatabaseBackup@Databases = 'ALL_DATABASES',@Directory = 'C:\DatabaseBackups\Daily\',@BackupType = 'FULL'
(Click here to see a list of all available options and parameters for the DatabaseBackup stored procedure
That should be the only changes to that blog post you’ll need to make, everything else should stay the same.
You can also check out Ola’s FAQ page, where he also offers a quick explanation on getting his solution up and running with SQL Server Express Edition.