Schedule SQL Server Express Backups with sqlcmd

April 27, 2012
| No Comments

backup.sql

BACKUP DATABASE [AdaptiveCR] TO  DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\AdaptiveCR.bak' WITH NOFORMAT, NOINIT,  NAME = N'AdaptiveCR-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO

MF20bak.cmd

sqlcmd -S .\SQLEXPRESS -i C:\backup.sql

Scheduled Tasks to call MF20bak.cmd

Setup, SQL Server