Solved

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

Posted on 2011-03-21
12
208 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
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
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

Backup Your Microsoft Windows Server®

Backup 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.

Question has a verified solution.

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

Suggested Solutions

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

815 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

13 Experts available now in Live!

Get 1:1 Help Now