Mixed Environments - SQL 2000 Standard && Enterprise??
Oct 6, 2005
We are upgrading a production database server to new hardware. The server is currently running SQL Server 2000 Standard Edition. We are thinking about installing SQL Server 2000 Enterprise Edition, however that would mean the test server (2000 Standard) and production server (2000 Enterprise) have different edtions of SQL Server. How much of a risk does this present? Later in the year we would upgrade test to SQL Server 2000 EE, but for a couple of months the environments would be different.
Thanks, Dave
View 3 Replies
ADVERTISEMENT
Nov 25, 2004
I need to max out on RAM somewhere around 3 to 4 GB and I am using SQL 2000. Standard SQL 2000 RAM is limited to 2 GB. SQL Enterprise 2000 is maxed out around 32GB and it cost is $1K. I need to purchase a Windows based SQL package but I can't find the specs on SQL Standard 2003 (which is ~$700) to compare.
What is the Max RAM for SQL Standard 2003?
Which is a better purchase relative to RAM?
What O/S is recommended as this also limits RAM usage?
View 1 Replies
View Related
Jan 12, 2006
I have kind of an urgent need here. I need to know if there is a dll file or registry key or something of that nature that I can query on to find out if my SQL 2000 installations are Enterprise or Standard.
I understand I can do this using query analyser, but that will not work with my reporting tool (this is for reporting numbers of SQL installations in our very large enterprise for Microsoft license compliance).
Thanks for any guidance!!
Cheryl Marland
cheryl.marland@va.gov
View 3 Replies
View Related
Feb 12, 2008
Hi All
I'm after some advice, I am looking for the best way to do this:
I have a SQL 2000 Clustered Virtual Instance which is of course Enterprise Edition as it is clustered. I need to upgrade to 2005, but dont need the 2005 Enterprise features, Standard will do, as this supports clustering.
The restrictions are that you cant upgrade 200Ent to 2005Std.
As this is a fairly complex environment, it has a default instance running on node 1 and a named instance running on node 2
I dont particularly want to uninstall both 2000 instances, and then install new 2005 instances
So is it possible to upgrade to 2005 ent, and then downgrade to standard. I have seen a suggestion without any details, that there is an undocumented sp, sp_update_resume, that might do this. Does anyone know about this
Or does anybody have any other suggestions. (the names of the instances have to be the same, as the existing instances)
Thanks in advance
Tom
View 1 Replies
View Related
Sep 6, 2007
Hi,
One of our main servers running on SQL Server 2000 Enterprise edition which has transactional replications on it which replicates to other servers running on the SQL Server 2000 Enterprise edition as well.
Due to Hardware problems the server is being migrated to a new machine but the client has installed SQL Server 2000 standard edition on the new machine.
We will be using a two processor cpu with 4GB RAM and we are also not planning about clustering. Is there any problem if i migrate the server in Standard Edition will the replications work properly between Standard and Enterprise editions.
What other complications can be there if i switch over to standard edition from enterprise edition
Thanks in ADVANCE
Jacx
View 1 Replies
View Related
Feb 21, 2008
Another DBA on my team is trying to tell me that it is a widely accepted best practice to only have a single version of SQL server in the enterprise environment. This seems counter intuitive to me and I cannot find a confirming source for this assertion.
I would think that it largely depends on your environment but that once a new version of SQL server has been decided on for a given application, for whatever reasons, that new version should be used moving forward on all new development.
It also seems like that as other databases grow and hardware comes to its end of life that older databases be either migrated or ported to the new version as seems appropriate.
Is there any reason an enterprise should always be on X version and only X version?
View 5 Replies
View Related
Jan 15, 2007
Hi there
Our ISP hosts our data on SQL Server Enterprise, but I also going to host the databases on my local machine.
As it's just local would Standard edition do? If I migrate the databases over, will it work?
Thanks in advance.
View 2 Replies
View Related
Sep 14, 2004
I am currently running SQL Server 2000 Standard on my production system, and I am looking to upgrade the system to Windows 2000 Adv. Server. I would also like to upgrade SQL Server 2000 Standard to SQL Server 2000 Enterprise to utilize more than 2GB of memory. Can anyone tell me what is the best way to upgrade the system, and please provide some feedback on your experiences with the upgrade. Thanks in advance.
View 2 Replies
View Related
Sep 15, 2006
Hi, I need to know if somebody knows like making the update of Standard SQL 2000 to Enterprise. Greetings.
View 3 Replies
View Related
Aug 2, 2006
How do SQL 2000 service packs play a role in upgrading? That is, can SQL 2000 Standard with no Service Packs(SP) be upgraded to SQL 2005 Standard, or does SQL 2000 Standard have to have a certain service pack??
View 1 Replies
View Related
Feb 26, 2008
Hello all,
Here I need some help or suggestions for the following topic...
I am using SQL server 2000 enterprise edition installed on the machine. Now I wanted to change the edition from enterprise to standard.
There are around 4 user databases exists on the server.
What are the areas I have to take care while doing this? Could I do as normal installation?
No log shipping implemented on the server.
Your suggestions would be very helpful to me.
Thanks in advance.
View 4 Replies
View Related
Feb 15, 2005
Is SQL Server 2000 Standard an option for a web application ? OR Only Enterprise version should be used for a web application because the standard version cannot support fully a web application?
View 6 Replies
View Related
Jul 24, 2007
Hi,
Can we degrade from SQL Server 2000 Enterprise Edition to SQL Server 2000 Standand Edition without doing Uninstall and reinstall?
Thanks in advance,
View 1 Replies
View Related
Nov 9, 2007
Hi,
I would like to find out if there is any way to upgrade SQL Server 2000 (Ent) to 2005 (STD)
The Instance has many logins and jobs etc and I dont want to loose those
A document or some advice on how to go about it would help
Thanks
View 10 Replies
View Related
Jan 17, 2006
Hi There
Currently in production we have a publisher, remote distributor, and subscriber all running 2000.
We
want to upgrade the subscriber and possibly the remote distributor to
2005 while leaving the publisher 200 for now, i need a good link or
article about the proper proceudre to accomplish this.
Thanx
View 3 Replies
View Related
Nov 20, 2002
Does anyone know if it is possible to go from the Enterprise edition of SQL, back to Standard?
In other words, Enterprise Edition is installed, but what we really want is Standard. Is there any way around this, other than uninstalling and reinstalling SQL?
I assume not, but thought I would check...
View 1 Replies
View Related
Nov 12, 2006
dear all,
if one has purchased enterprise edition of sql server, could he install the standard version instead of the enterprise one without violating software license?
regards
View 1 Replies
View Related
Dec 27, 2007
How are you, I was wondering if I could uninstall and reintall sql server standard and upgrade to enterprise edition.
What i mean..
We have 10 computers running sql server standard. We want to upgrade them to enterprise edition bc there are another 10 machines with enterprise.
Would we have to uninstall standard edition before installing enterprise.
Or could we just install enterprise edition over standard
Has anyone done this? Compatibilty issue?? We are doing it remotly as well, some machines in NC, some in Vegas, some in Cali. So all will be done through RDC.
any and all help will be great
Thanks
View 3 Replies
View Related
Oct 3, 2001
Is it possible to "convert" from SQL 7.0 Standard Edition to SQL 7.0 Enterprise Edition?
Thanks.
View 4 Replies
View Related
Nov 21, 2002
What's the best/easiest method to upgrade from Standard Edition to Enterprise Edition and still keep the databases in tact?
My thoughts were to:
1)Backup databases
2)Detach User Databases
3)Uninstall Standard
4)Install Enterprise
5)Restore Master and msdb
6)Reattach the User Databases
Comments?
View 1 Replies
View Related
Aug 7, 2003
How to know if it is standard or enterprise edition that a remote sql server is?
View 7 Replies
View Related
Feb 19, 2004
Recently, I worked on installing SQL Server 2000 into a clustered environement. I installed the Standard edition, tested it, and everything works fine. However, in reading some information on Enterprise Edition from Microsoft, I see where it says to install Enterprise Edition when using a clustered, or failover, environement. Can anyone give me a layman's explanation as to why this is? Everything is functioning just fine with the Standard Edition installed.
I really don't want to re-install if I don't have to.
Thanks in advance.
View 2 Replies
View Related
Nov 29, 2000
How can I find out if a sql 6.5 server was loaded with the Standard or Enterprise version of sql server?
thanks
View 2 Replies
View Related
Jan 9, 2002
Does any one know if the Standard or Enterprise version of SQL Server 2K allows Maintenance Procedures like "DBCC CHECKDB REPAIR_REBUILD" to execute with users logged in, without the requirment of single user mode on the Database?
Any help would appreciated.
View 2 Replies
View Related
Jul 17, 2007
In setting up replication between databases do both sql installations have to be enterprise or can it be done with both sql server standard edition.
thanks,
View 7 Replies
View Related
Apr 30, 2004
I'm setting up a new system and want to do a cluster. We have Win2k3 Enterprise already. My question is do you have to have enterprise edition of SQL2K to do clustering w/ win2k3?
View 7 Replies
View Related
May 16, 2006
Hello,
I have a question.
I want to migrate from mySql to Sql Server, and I should decide which version will I use.
The problem is that I need partitioning, and it is included only in the Enterprise version. But the Enterprise version costs 5 times more than the standard and the workgroup version.
Is it worth to spend so much money only for the partitioning?
Also, maybe I am wrong, and the partitioning is also included in the Standard version?
Thanks,
Edi.
View 15 Replies
View Related
Mar 18, 2007
Mustrum Ridcully writes "Sitting here at work trying to figure a way to find wether SQL server is Enterprise or Standard edition. Submitting this question won't probably help much as I have to deliver report in about 30min. Nevertheless, somebody might benefit from this information in the future.
Regards"
View 3 Replies
View Related
May 2, 2007
We've got a SQL 2000 Server running the Enterprise 120-day trial.Normally you can retain the information by upgrading it to the full-blown version of Enterprise edition. However, we have decided to gowith the Standard version instead. Will I need to BACKUP the data anddo a complete install then RESTORE or can I "upgrade" it to Standard?Has anybody actually done this?
View 1 Replies
View Related
Nov 29, 2006
I go to help>About and it just says SQL Server 2005
Microsoft SQL Server Management Studio Version 9.00.1399.00
View 7 Replies
View Related
Apr 11, 2007
I am running SQL 2005 Enterprise Edition on a 2 node cluster. Can I install SQL 2005 Standard edition on the same cluster?
View 2 Replies
View Related
May 28, 2008
hello all,
has anyone attempted (or succesfully implemented) a solution using Standard Edition, **as a replacement** for Enterprise Edition, in a multi-partition environment?
I believe one can use external partitions in SSAS to draw data from SQL Server, I'm not sure if that's a feature that works with the Standard Ed. of SSAS.
Namely, I'd like to see if I can use a setup of 4 installs of SQL Server, Standard Edition, and use that as a feed data into SSAS Standard Edition, and save some money on licensing (probably at a cost of increased maintenance). I know that the Enterprise version also has some enhanced analytics functions and other cool stuff so that'll be lost as well, with this potential setup.
My inclination is that to use external/Remote Partitions one would still need to use the Enterprise Edition, making this the only choice, for large cube builds -- but I may be wrong.
thanks much for any feedback,
Cos
View 3 Replies
View Related
Jul 17, 2002
I need to know if it is possible, and if so, the effects of restoring databases from a server running SQL Enterprise Edition to a server running SQL Standard Edition. There will be an application database as well as the "master" database to be restored.
Any suggestions?
View 1 Replies
View Related
