lee-pai-long
1/20/2016 - 2:24 PM

backup-database_sqlserver.md

[SQLSERVER] Backup database

Connect to server

> osql -S <SERVER>/<INSTANCE> -E

-E allow to connect without password

Backup the DB

> backup database <DATABASE> to disk="<X:\path\to\dumpfile>"

*X is generic for the partition letter ex C:*