sqlcmd to backup sqlexpress
Posted: Fri Jun 03, 2011 2:24 pm
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"