Solved

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

Posted on 2011-03-21
12
209 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
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
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Improvement  ( Speed) 14 33
Job - date manual 1 35
SQL Stored Proc - Performance Enhancement 15 58
TSQL recursive CTE challenge... 8 29
Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
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.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

820 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