Getting Started with Private SQL Server

Overview

A Private SQL Server gives you your own dedicated Microsoft SQL Server rather than a share of a common one. You manage its databases from the Everleap Control Panel, under Databases > Private MS SQL.

Creating databases

1. Log in to the Private SQL section of the Control Panel and click the Create MS SQL Database button.
2. Enter a database name, username and maximum disk space, then click the Create Database button.

The SQL disk space available to you is displayed at the top of the page.

The SA user

Each Private SQL server has an SA (system administrator) account created when the server is delivered. The username is in the format masterxxxx. You can change the password of the master user in the Control Panel.

Changing a database user password

1. Log in to the Private SQL section of the Control Panel and click the Manage link for the database you would like to change.
2. Click the Update link next to "Database Password: *****".
3. Enter the new password for the database user and click the Update Password button.

Connecting with Microsoft SQL Server Management Studio

1. Log in to the Private SQL section of the Control Panel.
2. Click the Manage link next to the database you would like to connect to. The connection parameters are displayed in the General Information section.
3. Open Management Studio and enter the connection parameters in the corresponding fields of the Connect to Server dialog box.

Restricting external access by IP address

With a Private SQL server you can restrict external access to only certain IP addresses. See How to Configure IP Restriction on your Private SQL Server.

Backing up a database

1. Log in to the Private SQL section of the Control Panel.
2. Click the Manage link next to the database you would like to back up.
3. Click the BACKUP link.
4. Select the site where you want the backup to be placed from the Site Location dropdown.
5. Click Create Backup.

Retrieving a backup from the SQL server

The SQL server automatically runs a nightly backup of the SQL databases. We retain 3 to 5 days worth of SQL backup.

1. On the Backup Private MS SQL Database page, scroll down to Retrieve Server Backup.
2. Click the Backup Date dropdown and choose the backup you want to retrieve.
3. Select the site where you want the backup to be placed from the Site Location dropdown.
4. Click the Retrieve Backup button.

Restoring a database

1. Upload a database file backup, with a .BAK extension, to the DatabaseBackup folder of your site.
2. Log in to the Private SQL section of the Control Panel.
3. Click the Manage link next to the database you would like to restore.
4. Click Restore.
5. Choose your site from the Site Location dropdown and enter the name of the backup file you uploaded to the DatabaseBackup folder.
6. Click the Restore Backup button.

Verify it worked

After creating a database, it appears in the list in the Private SQL section with the username and disk space you set. After a backup, the backup file appears in the DatabaseBackup folder of the site you selected, where you can download it by FTP.

Notes

• To add more disk space, memory or CPU cores to your Private SQL Server, please contact the billing department.
• Additional logins are created in the Control Panel and then assigned to a database through SQL Server Management Studio. See the article below.

Related Articles

• How to Configure IP Restriction on your Private SQL Server
• Additional logins for private MS SQL
• Getting Started with MS SQL Server databases
• Getting started with SQL Reporting Services