Help Center

Version 2.0

• Email Support: Submit a Ticket

• Windows-Based Databases
• MS SQL

Related Articles

• What are the Database Publishing Service and Database Publishing Wizard?
• Importing MS SQL 2005 Databases into MS SQL 2008 Databases
• What version of SQL Server is supported by the Database Publishing Service and Database...
• What should I be aware of when using the Database Publishing Service in the hosted environment?
• What does my Database Publishing Wizard error mean?
• Limitations of the Database Publishing Service in the Shared Hosting Environment
• Where can I get more information on the Database Publishing Wizard client?

What are the Methods for Backing up my MS SQL Database?

There are several methods for backing up a MS SQL database.

Dump

A copy of the database in ASCII(text) form. This file uses a series of SQL statements that build the database. This is the most common format to backup a MS SQL database and can be obtained through your account manager.

XML Export

A copy of the database in CSV or XML format. This format provides the data with no style or structure. This format can be obtained through your account manager.

NOTE: A copy of the database in .CSV format can only be imported.

Backup (.bak file)

A single file that contains all of the database content and structure. This format can be directly imported to another MS SQL server. For more information, see Backing Up a SQL Server Database.

For more information about backing up your MS SQL database, see How do I export a SQL Server Database?

• Not helpful
• Somewhat helpful
• Helpful
• Very Helpful
• Solved my problem