Solved

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

Posted on 2011-03-21
12
207 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
 
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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

910 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

22 Experts available now in Live!

Get 1:1 Help Now