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
• What are the Methods for Backing up my MS SQL Database?
• 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?

What is the difference between a system backup and a user backup?

There are two types of backup: System Backup and User Backup. Here is a list of differences between the two back-up file types:

How Back-Up Files are Created:

• System Back-up Files - created automatically by our system each night.
• User Back-up Files - created by the customer using the back-up feature in the Hosting Control Center. Alternatively, you can upload MySQL database files to _db_backups folder on the root level of the hosting account.

• System Back-up Files - stored on servers inaccessible to the user.
• User Back-up Files - stored in the_db_backups folder on the root level of the your hosting account.

• System Back-up Files - managed by our system, which periodically creates and replaces these files.
• User Back-up Files - managed by the user. Using an FTP client, you can download, upload, rename, and delete these files.

• System Back-up Files - use the database name followed by a date stamp.
• User Back-up Files - use the database name followed by a date stamp. While you cannot define a filename during the back-up process, you can rename a file once the process is complete.

Note: You must use the appropriate filename extension when renaming any back-up file: MySQL files use the .sql extension. SQL Server files use the .bak extension.