Just a follow up to my previous post, covering the Automation of SQL Express Backups…
As Brian’s scripts are aimed at non-techies, he wisely coded them to backup all SQL databases on the host. If you’d prefer to back up just one specific SQL database, all you need to do is:
Open up BackupExpress.sql in an editor.
Find … Read more »
If you’ve ever struggled with configuring automated, scheduled backups for a SQL Express server, then check out Brian Knight’s super handy scripts.
The script contains three files:
BackupExpress.sql – Does the bulk of the work, backing up every database on the instance other than tempdb.
BackupExpress.cmd – The batch file that executes the script. Must pass in the … Read more »