Script for Backing up SQL Server Express Databases with Email Notification

See the attached script. It allows for backup of up to 10 SQL express databases, and emails the result via BLAT. Be sure to run BLAT.exe -InstallSMTP to setup your SMTP server and sender address.

Change the variables to match your environment, as follows.

rem --Set Databases to Backup
set DB1=Database1
set DB2=Database2
set DB3=
...

rem --Set Paths
rem Path to backup to
set BUPATH=D:\SQLBackups
rem Path to this script and BLAT
set BUPROGPATH=D:\Processes\SQLBackup
rem Backup email recipient
set BURECIP=address@domain.com

Attached files: