Help Center

Version 2.0

• Windows Hosting
• Working with Databases

Help Center Search

Related Articles

• Connecting to a Microsoft SQL Server Database Using ASP/ADO
• Connecting to a MySQL Database Using ASP/ADO
• What MySQL Server Features are Disabled on my Shared Hosting Account?
• Do you restrict any features in MySQL 4.1/5.0?
• What is MARS and how do I use it?
• What are the major differences between MySQL 4.0 and 4.1/5.0?
• Is there a size limit on MS SQL databases?

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. 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