Solved

Doing a SQL2008 and SQL2000 Side by Side Install

Posted on 2011-03-22
5
277 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 68

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 68

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

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
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

707 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now