Solved

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

Posted on 2011-03-21
12
211 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 6
12 Comments
 
LVL 14

Accepted Solution

by:
Daniel_PL earned 500 total points
ID: 35180510
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
ID: 35180542
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
ID: 35180546
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
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 14

Expert Comment

by:Daniel_PL
ID: 35180581
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
ID: 35180723
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
ID: 35180747
Sure, off course :)
0
 

Author Comment

by:Rmumpower00
ID: 35189039
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
ID: 35189047
Nicely Done!
0
 

Author Comment

by:Rmumpower00
ID: 35194017
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
ID: 35196139
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
ID: 35197818
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
ID: 35197841
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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
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.
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

724 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