MSSQL Server Backup / Import

To backup your database use following SQL:

BACKUP DATABASE <databaseName> TO DISK = '<pathToSqlFile>'

To import an existing dump use following SQL:

RESTORE DATABASE <databaseName> FROM DISK = '<pathToSqlFile>'