sqlcmd to backup sqlexpress

[thockman]

Simple cmd to backup express. Throw it in a cmd file and have at it.

Code: Select all

sqlcmd -S .\sqlexp_instance -Q "backup database dbname to disk = "path\filename.bak"