Solved

Doing a SQL2008 and SQL2000 Side by Side Install

Posted on 2011-03-22
5
281 Views
Last Modified: 2012-05-11
If I do the SQL 2008 install and something goes wrong, since it's side by side, can I just uninstall SQL 2008 and all will be back to normal with SQL 2000?
0
Comment
Question by:Rmumpower00
  • 2
  • 2
5 Comments
 
LVL 32

Expert Comment

by:ewangoya
ID: 35194125

The will be installed as different instances. If one is no good you can just uninstall it leaving the other in working order
0
 
LVL 69

Expert Comment

by:Qlemo
ID: 35194558
The only thing to care about is which one of both BINN folders comes first if you use tools with the same name, in particular the Legacy stuff like DTS. So nothing severe can happen on a site-by-site installation.
0
 

Author Comment

by:Rmumpower00
ID: 35197805
Right before the install it showed a screen where shared components were listed and I seen that the SQL2000 Enterprise Manager was being shared. Is this right? I stopped the install until I get a chance to check my Virtual test machine.
0
 
LVL 69

Accepted Solution

by:
Qlemo earned 500 total points
ID: 35198256
No, the Enterprise Manager is not shared. It cannot be used to access 2008 instances.
0
 

Author Closing Comment

by:Rmumpower00
ID: 35198934
Thank you for your help
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question