Resellers: MS SQL 2005 FAQ
Posted by Jay Sudowski (Import) on 11 December 2006 01:29 PM

Helm Integration
MS SQL 2005 will be directly integrated into Helm, allowing you and your customers easily add MS SQL 2005 databases without contacting our support team for assistance. We will also be billing you based upon the database size report found in Helm. Moreover, please note that your customers will not be able to create MS SQL 2005 databases unless you modify your hosting plan quotas.

Generating Database Size Report
In order to generate the database size report, please follow these steps:

  1. Login to Helm
  2. Click on Reports
  3. Click on Customer Database Size Report
  4. Click on "Export Report: Microsoft Excel". This will export the entire report to Excel so that we can sort and isolate just the MS SQL 2005 databases.
  5. Once the report is open in Excel, sort by Database Type. If the database type is MSSQL, then this is a MS SQL 2005 database.

Enabling Your Customers To Create MS SQL 2005 Databases
Before your customers can create MS SQL 2005 databases, you must modify your hosting plan quotas. Please follow these steps:

  1. Login to Helm
  2. Click on Hosting Plans
  3. Click on the Plan Name
  4. Click on "Resource Limits"
  5. Click on "Database Resources ".
  6. Modify the "MSSQL Server 2005 Databases " quota accordingly. If this value remains set at 0 your customers will not be able to create any MS SQL 2005 databases.
  7. Click "Save".

After you modify your quotas, please follow this procedure to create the databases.

Managing Your MS SQL 2005 Databases
After your customer creates their database through Helm, they will be provided with the IP address and port number to connect to for the SQL Server that hosts their database. For security reasons, we will not be providing this information on the knowledgebase. Please open a ticket if you have any questions about the IP address/port number. Please note, SQL Server Enterprise Manager cannot be used to manage MS SQL 2005 databases. Your customers must download SQL Server Management Studio in order to remotely manage their databases.

Rate Plans & Billing Examples
MS SQL 2005 databases will be billed at the end of each calendar month. You will be billed for the total space consumed by all of your MS SQL 2005 databases, including transaction logs. The minimum billable database size will be 20MB. Additionally, you will be automatically upgraded to the next pricing/usage tier if it is cheaper.

Rates:

  • 20MB - 100MB: $.35/MB
  • 101MB - 500MB: $.30/MB
  • 501MB - 1000MB: $.25/MB
  • 1001+MB: $.20/MB

Example 1
Your customers have created the following databases:

  • Database 1: 16MB
  • Database 2: 22MB
  • Database 3: 38MB
  • Database 4: 125MB

Database 1 is less than 20MB, so it will be billed at 20MB. Including this exception, there is 205MB of billable database space. The total cost for these databases is $61.50/mo (205MB * $.30 = $61.50).

Example 2
Your customers have created the following databases:

  • Database 1: 20MB
  • Database 2: 22MB
  • Database 3: 25MB
  • Database 4: 28MB

All databases are over 20MB, so they are billed based upon their actual size. In total, there is 95MB of billable database space. At the $.35/MB rate plan, the cost for these databases is $33.60/mo (95MB * $.35 = $33.60). However, if your usage was increased to the next tier, the cost is only $30.30 (101MB * $.30 = $30.30). You will be charged the lower rate of $30.30.

Existing MS SQL 2000 Databases
Any existing MS SQL 2000 databases you have hosted with us will not be automatically upgraded to MS SQL 2005. Additionally, the current MS SQL 2000 rates will remain unchanged. If you have any existing MS SQL 2000 databases you want upgraded, please create them in Helm, create the appropriate database users in Helm, and then provide us with the following information:

  • Existing Database Name:
  • New Database Name:
  • Existing Username/Password:
  • New Username/Password:

    NOTE: The new database name and username/password must already be created in Helm and must match the information noted in Helm. If they do not, we cannot proceed with moving your database.

Once we have this information, we will detach your database from the SQL 2000 server and attach it to the SQL 2005 server. During this period, your database/site that uses this database will be down until you update your connection strings and DSN information with the SQL 2005 database information. For this reason, we suggest that you plan on a maintenance window of up to one hour when your site is moved. While we should be able to move most databases within a few minutes, your site will not be functional again until you update your connection strings.

(752 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).