Script for Backing up SQL Server Express Databases with Email Notification

~ 0 min
2021-02-02 18:30

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=[email protected]

Attached files:

Average rating 0 (0 Votes)

You cannot comment on this entry