Backup MSSQL DataBase

Useful for normal backups or if running a script, here is how to backup a MSSQL database. This example backs up database PEEKABOO and puts the backup in C:\backup\db.bak, change your names and path to reflect your needs/setup.

"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\osql.exe" -E -Q "BACKUP DATABASE peekaboo TO DISK='C:\backup\db.bak' WITH FORMAT"