Backup an MSSQL database

Users can run a .sql dump to backup their MSSQL databases. Instructions on how to do this are below:

Create a .sql dump using EMS SQL Manager for SQL Server

Using the Extract Database Wizard you can extract database objects and data to an SQL script.

  1. Select Tools
  2. Extract Database menu item from the menu bar
  3. Select Save to file
  4. Click Next
  5. Select Extract both structure and date
  6. Click Finish