Skip to content

Instantly share code, notes, and snippets.

@lee-pai-long

lee-pai-long/backup-database_sqlserver.md

Created January 20, 2016 14:24
Show Gist options
  • Save lee-pai-long/b7bd50284e5f37cde6ff to your computer and use it in GitHub Desktop.
Save lee-pai-long/b7bd50284e5f37cde6ff to your computer and use it in GitHub Desktop.
Download ZIP
Raw
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:*

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment