Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / DB Engine / SQL Server / August 2008

Tip: Looking for answers? Try searching our database.

Can I Install SQL Server 2000 Developer's Edition

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
allanc - 30 Aug 2008 02:06 GMT
I have a Windows 2003 server with SQL 2005 Standard Edition sp1
installed.

I need to install SQL Server 2000 Developer's Edition.

Are there any tips or traps that I should be aware of?

TIA.
Russell Fields - 30 Aug 2008 16:43 GMT
Allanc,

Yes, you can have both on Windows 2003 server.

However, tools issues mean that it is best to install SQL Server 2000 first
(even if it goes into a named instance), then install SQL Server 2005
afterward.  For compatability reasons, SQL Server 2000 should be at SP3 or
SP4.

But your SQL Server 2005 is already installed. Do you have a test machine to
try this on?  If so, you could go through the paces a couple of times and
work out the problems.

I have not had to do this, but to play it safe I would suggest that you
should:
1. Backup the SQL Server 2005 databases, then detach the user databases.
2. Uninstall SQL Server 2005.
3. Install SQL Server 2000 as a named instance.
4. Reinstall SQL Server 2005 as it was before (either the default instance
or a named instance).
5. Restore master and msdb from backup for the SQL Server 2005 instance.
6. Reattach the user databases to SQL Server 2005.

FWIW,
RLF

>I have a Windows 2003 server with SQL 2005 Standard Edition sp1
> installed.
[quoted text clipped - 4 lines]
>
> TIA.
allanc - 30 Aug 2008 22:20 GMT
Thank you.

On Aug 30, 11:43 am, "Russell Fields" <russellfie...@nomail.com>
wrote:
> Allanc,
>
[quoted text clipped - 32 lines]
>
> - Show quoted text -
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.