Getting started with Private SQL Server

Creating databases

  • Log in to the Private SQL section of Control Panel and click the Create MS SQL Database button.
  • Enter a database name, username and maximum disk space (available SQL disk space is displayed at the top of the page) and click the Create Database button.

 

Changing a database password

  • Log in to the Private SQL section of Control Panel and click the Manage link for the database you would like to change.
  • Click the Update 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 the Private SQL section of Control Panel.
  • Click the Manage link next to the database you would like to connect to. The connection parameters 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 a database

  • Log in to the Private SQL section of Control Panel.
  • 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 Create Backup.
 
 
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 Private MS SQL Database page scroll down to the Retrieve Server Backup.
  • Click on the 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 the Private SQL section of Control Panel.
  • Click the Manage link next to the database you would like to restore.
  • Click Restore.
  • Choose your 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.

 

To add more disk space, memory or CPU cores to your Private SQL Server, please contact the billing department.