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 the Update Password button.

Connecting to a database with Microsoft SQL Server 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.

• 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.