Sql Server Express Automate Backup

Create a backup SQL script for database name and location then create a scheduled task from the following batch file command

 

“C:\Program Files\Microsoft SQL Server\100\Tools\Binn\SQLCMD.EXE” -S RTMTERMSERVER\WZ -i c:\WZBU\WZBackup.sql

SERVERNAME                                Location of SQL Script