Help Center

Version 2.0

• Windows Hosting
• Working With Databases

Related Articles

• Connecting to an Access Database Using File DSN and ASP/ADO
• What are the limitations for MS SQL?
• Connecting to a Microsoft SQL Server Database Using ASP/ADO
• Which Databases do you Support on Your Windows Hosting Accounts?
• How do I connect to SQL Server using Visual Studio?
• What are the Limitations for MySQL?
• How do I Recompile the MySQL Library to Run Under the Medium Trust Environment?
• Connecting to a MySQL Database Using ASP/ADO

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 MySQL 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. A database in this form must be obtained through customer support and a fee may apply.

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