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 _database directory. 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:
- Upload a .bak file generated by the Backup Database Tool to your web site
- Log in to the MS SQL 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, \_database\backup.bak
- Click the "Restore Backup" button
Attach MDF file tool
This tool allows you to attach a local SQL database or local SQL Express data file to the SQL database hosted on our server.
Note: all existing data in the database will be overwritten!
Note: To connect to an MS SQL database you must use the SQL Server Management Studio.
Follow the steps below to attach a database:
- Detach the local SQL database. There are various ways to do this:
- Using VS.NET/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 MS SQL Manager 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.