November 26, 2007 at 11:09 pm
Are there any issues restoring a database being used in SQL 2000 Enterprise Sp4 to another server running SQL 2000 Standard?
We are upgrading 1 server to SQL 2000 Enterprise but leaving another server (used for reporting) at SQL 2000 Standard. I am worried about the compatability between the 2 versions.
Thanks
November 27, 2007 at 1:06 am
Hi Devon,
Memory you are limited to 2 G and 4 CPUs
Check thoses links for more info
Comparison Between SQL Server 2005 Standard and Enterprise Editions
http://www.microsoft.com/sql/editions/enterprise/comparison.mspx
difference between SQL 2000 Enterprise/Standard
http://www.mssqlcity.com/FAQ/General/sql_server_2000_editions.htm
Standard Edition can work on the Windows NT Server 4.0 with Service Pack 5, Windows NT Server 4.0 Enterprise Edition and on the Windows 2000 Server/Advanced Server/DataCenter.
This edition has the following restrictions:
maximum 4 CPU (up to 8 CPU on the Windows NT Enterprise Edition)
no Distributed Partitioned Views
no Log Shipping
no Parallel index creation
no Failover clustering
maximum 2Gb RAM
Enterprise Edition can work on the Windows NT Server 4.0 with Service Pack 5, Windows NT Server 4.0 Enterprise Edition and on the Windows 2000 Server/Advanced Server/DataCenter.
This edition can use:
up to 32 CPU on the Windows 2000 DataCenter up to 8 CPU on the Windows 2000 Advanced Server and on the Windows NT Server 4.0 Enterprise Edition up to 4 CPU on the Windows NT Server 4.0 and on the Windows 2000 Server
up to 64Gb RAM on the Windows 2000 DataCenter up to 8 Gb RAM on the Windows 2000 Advanced Server up to 4 Gb RAM on the Windows 2000 Server up to 3 Gb RAM on the Windows NT Server 4.0 Enterprise Edition up to 2 Gb RAM on the Windows NT Server 4.0
Distributed Partitioned Views
Log Shipping
Parallel index creation
Failover clustering
Effects of moving a database from SQL Server 2000 Enterprise Edition to SQL Server 2000 Standard Edition
http://support.microsoft.com/kb/268361
Differnces Enterprise/Standard
http://www.databasedev.co.uk/ms-access-vs-sql-server.html
SQL Server 2000 Enterprise Edition:
SQL Server 2000 Enterprise Edition is the most comprehensive of all SQL Server 2000 editions.
It provides database management as well as advanced analysis features. It is designed to scale for large web sites, on-line transaction processing and data warehousing.
SQL Server 2000 Standard Edition:
SQL Server 2000 Standard Edition provides both data management and analysis as a small and medium sized business solutions.
It provides essential database management functions in addition to reporting services, which provide database intelligence and analysis services to evaluate data.
Microsoft Support Lifecycle
http://support.microsoft.com/lifecycle/?p1=2852
Regards,
Ahmed
November 28, 2007 at 7:26 am
Hey,
In short, there is no compatibility issue with restoring an enterprise database to standard.
What you lack, as Ahmed pointed out is a lot of functionality. So you just need to be aware of the links in this post and make sure the database you want to restore to standard does not rely on them.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply