Getting started with MS SQL Server databases

Creating a database

  • Log in to Control Panel and go to the MS SQL Databases section.
  • Click the Create MS SQL Databases button.
  • Enter the suffix for your new database and the quota (available SQL disk space is displayed at the top of the page) in the respective fields and click the Create Database button.

 

Changing a database password

  • Log in to Control Panel and go to the MS SQL Databases section.
  • Click the Manage link next to the database you would like to update.
  • Click the Edit link next to "Database Password: *****"
  • Enter the new password for the database user and click Update Password.

 

Connecting to a database with MS Management Studio

  • Log in to Control Panel and go to the MS SQL Databases section.
  • Click the Manage link next to the database you would like to connect to. The connection parameters to the database will be displayed in the General Information section.
  • Open Management Studio and enter the connection parameters in the corresponding fields of the Connect to Server dialog box.

 

Backing up an MS SQL database

  • Log in to Control Panel and go to the MS SQL Databases section.
  • Click the Manage link next to the database you would like to back up.
  • Click the backup link.
  • Select the site where you want the backup to be placed from the Site Location dropdown.
  • Click the Create Backup button.
 
 
Retrieving a backup from the SQL server
  • The SQL server automatically runs nightly backup of the SQL databases.
  • We retain 3 to 5 days worth of SQL backup.
  • Under the Backup MS SQL Database page scroll down to the Retrieve backup from SQL backup server.
  • Click on the SQL Backup Date drop down and choose the desired backup to retrieve.
  • Select the site where you want the backup to be placed from the Site Location dropdown.
  • Click the Retrieve Backup button.

 

Restoring a database

  • Upload a database file backup (with .BAK extension) to the DatabaseBackup folder of your site.
  • Log in to Control Panel and go to the MS SQL Databases section.
  • Click the Manage link next to the database you would like to restore.
  • Click the restore link.
  • Choose the site from the "Site Location" dropdown, enter the name of the backup file that you uploaded to the DatabaseBackup folder.
  • Click the Restore Backup button.