What is a simple command line program or script to backup SQL server databases?

Question

I've been too lax with performing DB backups on our internal servers.

Is there a simple command line program that I can use to backup certain databases in SQL Server 2005? Or is there a simple VBScript?

Answer 1

To backup a single database from the command line, use osql or sqlcmd.

"C:Program FilesMicrosoft SQL Server90ToolsBinnosql.exe" 
    -E -Q "BACKUP DATABASE mydatabase TO DISK='C:mpdb.bak' WITH FORMAT"

You'll also want to read the documentation on BACKUP and RESTORE and general procedures.