NOTE: The SQL tool suite can be found the database manager section of the control panel.
Shrink Database tool
This tool shrinks the data file to help customers reduce their SQL disk
space usage. It is recommended that you run this tool when your
database size grown to 80% of the allotted size. We do not recommend
running this tool more than once a day.
Backup Database tool
This tool creates a real-time backup of your SQL database and copies
the file to your web site root. The file will be named:
<DBNAME>_backup.bak or <DBNAME>_backup.zip, depending on
the backup format that you choose.
We recommend using the zip
format for backups that you are
archiving, as the file size is considerably smaller than the bak file,
so your downloading and storage requirements will be much less. If you
are making a backup for rollback purposes (for example, before making a
change to your database), use the bak format.
You can only save one copy of each format of database backup in your site (1 zip and 1 bak).
The .bak format database backup is intended for restoration on our
database server. Though technically possible, we cannot provide support
for restoring a database backup from your own SQL server.
Restore Database tool
This tool allows you to restore a database backup (generated by the Backup Database Tool) to your database.
Note that a zip file cannot be uploaded and used to restore your database
, and that all existing data in the database will be overwritten when you use this tool!
Follow the steps below to restore a database:
Attach MDF file tool
- Upload a .bak file generated by the Backup Database Tool to your web site
- Log in to the SQL 2005 Manager in your control panel
- Navigate to the "SQL Tools" menu
- Select the database you want to restore the .bak file to
- Enter the path to the .bak file. For example, \backup.bak
- Click the "Restore Backup" button
This tool allows you to attach a local SQL 2005 or local SQL 2005
Express data file to the SQL 2005 database hosted on our server.
all existing data in the database will be overwritten!
Follow the steps below to attach a database:
- Detach the local SQL database. There are various ways to do this:
- Using VS.NET 2005/Visual Web Developer:
- Right click on the database icon in the Solution Explorer
- Select "Detach"
- Using SQL Management studio:
- Open SQL Management Studio
- Expand the database node
- Right click on the database you want to upload/attach to our SQL server
- Select Tasks -> Detach
- Upload the database file (.mdf) to your web site
- Log in to the SQL 2005 section in your control panel and navigate to the SQL Tools tab
- Select the database you want to attach the MDF file to
- Input the path to the .mdf file. For example, \club.mdf
- Click the "Attach Database" button
Reset Database tool
This tool allows you to drop and recreate your database. It will recreate it using the same database name and the same primary database user name.
Note the following:
- The primary database username password will be reset to match the current hosting account password.
- All data, DB objects, and custom permissions on the database will be lost and reset to its default state.
- All additional database users will have to reassigned its proper roles. Please refer to this knowledge base. How to assign additional SQL servers to your database.
Article ID: 191, Created On: 11/13/2008, Modified: 8/30/2011