Difference between revisions of "Editions - MS SQL"
From Hostek.com Wiki
(→Express Edition Limitations) |
(→SQL Express and SQL Web Limitations) |
||
| (9 intermediate revisions by 6 users not shown) | |||
| 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=== | ||
For access to MyLittleAdmin and MyLittleBackup for VPS customers additional licensing is required, please contact support. | For access to MyLittleAdmin and MyLittleBackup for VPS customers additional licensing is required, please contact support. | ||
| − | ==== | + | ====Backwards Compatibility==== |
| + | Older versions of databases can be imported onto newer MSSQL servers, but newer versions cannot be used on older MSSQL servers. | ||
| − | MS SQL | + | *A MSSQL 2008 database can be imported into MSSQL 2012, however, a MSSQL 2012 database cannot be used on a MSSQL 2008 server. |
| + | |||
| + | ====SQL Express and SQL Web Limitations==== | ||
| + | |||
| + | |||
| + | MS SQL Express 2014 | ||
*Max Database size 10 GB in size | *Max Database size 10 GB in size | ||
*Max RAM utilization 1 GB Ram | *Max RAM utilization 1 GB Ram | ||
| + | MS SQL Web 2014 | ||
| + | *Max Database size 524 PB in size | ||
| + | *Max RAM utilization 64 GB Ram | ||
| − | MS SQL 2008 | + | |
| + | MS SQL Express 2012 | ||
| + | *Max Database size 10 GB in size | ||
| + | *Max RAM utilization 1 GB Ram | ||
| + | |||
| + | To manage SQL 2012, please see our SQL Server 2012 Wiki [https://wiki.hostek.com/SQL_Server_2012 here] | ||
| + | |||
| + | |||
| + | MS SQL Express 2008 | ||
*Max Database size 4 GB in size | *Max Database size 4 GB in size | ||
*Max RAM utilization 1 GB Ram | *Max RAM utilization 1 GB Ram | ||
| Line 21: | Line 38: | ||
'''NOTES:''' | '''NOTES:''' | ||
*For supporting a busy database or several databases with normal usage we recommend the Web edition with available RAM over 1GB. | *For supporting a busy database or several databases with normal usage we recommend the Web edition with available RAM over 1GB. | ||
| − | * | + | *'''Scheduled Tasks''': If you need to use Scheduled Tasks with the SQL Agent, you will need the Web Edition or higher. |
====Web Edition Limitations==== | ====Web Edition Limitations==== | ||
| Line 27: | Line 44: | ||
*Cannot be a Publisher for SQL Replication, for supporting SQL Replication and publishing we recommend the Standard Edition | *Cannot be a Publisher for SQL Replication, for supporting SQL Replication and publishing we recommend the Standard Edition | ||
| + | |||
| + | ====MS SQL Editions Comparison==== | ||
| + | [http://msdn.microsoft.com/en-us/library/cc645993.aspx MS SQL Edition Comparisons (Microsoft chart)] | ||
[[Category:Databases-MSSQL]] | [[Category:Databases-MSSQL]] | ||
[[Category:Databases-VPS]] | [[Category:Databases-VPS]] | ||
Latest revision as of 22:58, 16 December 2016
Contents
MS SQL Databases
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.
Backwards Compatibility
Older versions of databases can be imported onto newer MSSQL servers, but newer versions cannot be used on older MSSQL servers.
- A MSSQL 2008 database can be imported into MSSQL 2012, however, a MSSQL 2012 database cannot be used on a MSSQL 2008 server.
SQL Express and SQL Web Limitations
MS SQL Express 2014
- Max Database size 10 GB in size
- Max RAM utilization 1 GB Ram
MS SQL Web 2014
- Max Database size 524 PB in size
- Max RAM utilization 64 GB Ram
MS SQL Express 2012
- Max Database size 10 GB in size
- Max RAM utilization 1 GB Ram
To manage SQL 2012, please see our SQL Server 2012 Wiki here
MS SQL Express 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.
- Scheduled Tasks: If you need to use Scheduled Tasks with the SQL Agent, you will need the Web Edition or higher.
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