Difference between revisions of "Editions - MS SQL"

From Hostek.com Wiki
Jump to: navigation, search
(Express Edition Limitations)
(Shared Hosting Considerations)
Line 2: Line 2:
  
 
===Shared Hosting Considerations===
 
===Shared Hosting Considerations===
Microsoft SQL Server Web edition is used for serving our customers shared accounts. We also offer MyLittleAdmin and MyLittleBackup to our shared customers through the WCP.
+
Microsoft SQL Server 2012 Web edition is used for serving our customers shared accounts. We also offer MyLittleAdmin and MyLittleBackup to our shared customers through the WCP.
  
 
===VPS Hosting Considerations===
 
===VPS Hosting Considerations===

Revision as of 15:28, 24 June 2013

MS SQL Databases

Shared Hosting Considerations

Microsoft SQL Server 2012 Web edition is used for serving our customers shared accounts. We also offer MyLittleAdmin and MyLittleBackup to our shared customers through the WCP.

VPS Hosting Considerations

For access to MyLittleAdmin and MyLittleBackup for VPS customers additional licensing is required, please contact support.

Express Edition Limitations

MS SQL 2012

  • Max Database size 10 GB in size
  • Max RAM utilization 1 GB Ram

To manage SQL 2012 [Download SQL Management Studio 2012]


MS SQL 2008

  • Max Database size 4 GB in size
  • Max RAM utilization 1 GB Ram


NOTES:

  • For supporting a busy database or several databases with normal usage we recommend the Web edition with available RAM over 1GB.

Web Edition Limitations

  • Full-text indexing is not installed by default, request should be made to support for installing with full-text indexing.
  • Cannot be a Publisher for SQL Replication, for supporting SQL Replication and publishing we recommend the Standard Edition