Solved

I am wanting to install SQL 2008 side by side with SQL 2000

Posted on 2011-03-21
12
205 Views
Last Modified: 2012-05-11
Hello,
We are currently running Windows Server 2008 with SQL2000sp4. Within this environment we have multiple DTS Packages that are important to our day to day operations. One of the Software Applications we use is a Real Estate Application. We are in need of upgrading that to its newest version; unfortunately the newest version is not compatible with SQL2000. We are wanting to Install SQL2008 on the machine as a Side by Side install with SQL2000 so we can upgrade our Software in the future. Our intent is to install SQL 2008 side by side with 2000 so it is sitting there until the Software Consultants can come in and upgrade our Application. What we need is the DTS Packages we are currently using will continue to operate flawlessly after the installation of SQL 2008.

If I install SQL 2008 as a New Installation and install it side by side with the SQL 2000, will everything operate normally until we start migrating things over?

So, I guess to make this where it's clear, we kind of just want SQL 2008 to just sit there and behave while we continue to do our daily operations working with SQL 2000 until it's time to migrate over.

Should I be scared to do this Install?
0
Comment
Question by:Rmumpower00
  • 6
  • 6
12 Comments
 
LVL 14

Accepted Solution

by:
Daniel_PL earned 500 total points
Comment Utility
Sure, just install new named instance. Please keep in mind to properly set up memory settings and wisely choose disks for databases because two instances will compete for resources.
You can read great article about migration:
http://www.sqlmag.com/article/sql-server-2005/how-to-upgrade-to-sql-server-2008-from-sql-server-2000.aspx
http://www.sqlservercentral.com/articles/Administration/2987/
0
 
LVL 14

Expert Comment

by:Daniel_PL
Comment Utility
You can also migrate your dts packages to SSIS version:
http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/upgradingsqlserver2000dtspackagestossis/2201/
http://www.sqlmag.com/article/sql-server-2005/how-to-upgrade-to-sql-server-2008-from-sql-server-2000/3.aspx

Please take into account additional impact on resources of using new instance on the same machine.
0
 

Author Comment

by:Rmumpower00
Comment Utility
Daniel,
Thank you for your very fast response. To prepare myself for the install, I created a Virtual machine using Oracle VM Virtualbox and I did the install on that Virtual Machine probably a good 5 or 6 times now and I don't recall it ever asking for me to set up memory settings and disks for databases. Is this something I need to go look for?
0
 
LVL 14

Expert Comment

by:Daniel_PL
Comment Utility
That's because it was installed with default settings - as it always is. I suggest you to take into account reducing at least default value of max server memory:
http://sql-server-performance.com/Community/blogs/satya/archive/2008/03/14/142601.aspx
0
 

Author Comment

by:Rmumpower00
Comment Utility
Daniel,
Thank you so much for your help. Do you mind if I keep this open for a few hours so I can read over everything and ask any questions I have on the White Papers you've linked me too?
0
 
LVL 14

Expert Comment

by:Daniel_PL
Comment Utility
Sure, off course :)
0
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 

Author Comment

by:Rmumpower00
Comment Utility
I am going to do some tests today with Windows Server 2008 Backup to see if it will roll back to SQL 2000 if I mess up. If I can take a Backup of the Server before the install and it will roll back with the backup then I feel very confident in this and should go ahead and start the side by side tomorrow.
0
 

Author Closing Comment

by:Rmumpower00
Comment Utility
Nicely Done!
0
 

Author Comment

by:Rmumpower00
Comment Utility
Daniel, if you're still around. 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
 
LVL 14

Expert Comment

by:Daniel_PL
Comment Utility
Since it is side by side installation of SQL 2008 with SQL Server 2000 none of it components are upgraded. Some widnows components may change e.g. .NEt framework which version 3.5 is needed to install SQL server 2008.
Could you describe problems you are facing after installing another instance?
0
 

Author Comment

by:Rmumpower00
Comment Utility
I haven't installed yet, I was going to do it last night but came to a spot in the build up of the install where it showed Shared Components and listed the SQL 2000 Enterprise Manager and I stopped the install until I made sure that it would not harm my SQL2000.
0
 
LVL 14

Expert Comment

by:Daniel_PL
Comment Utility
You need to install new instance if you want side by side upgrade not upgrade existing install - if I understand you correctly.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Join & Write a Comment

In this article I will describe the Backup & Restore 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.
In this article I will describe the Copy Database Wizard 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.
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

762 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

6 Experts available now in Live!

Get 1:1 Help Now