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.

• Each Private SQL server has a SA (system administrator) account created when the server is delivered.  The username should be in the format of masterxxxx.  You can adjust the password of of the master user in the control panl.

Changing a database user 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.

• With Private SQL server, you can restrict external access to only certain IP addresses.  See https://support.everleap.com/kb/a1679/how-to-configure-ip-restriction-on-your-private-sql-server.aspx
  

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.