May 11, 2009 at 6:05 am
Hi All,
I have a SQL SERVER 2000 BOX where i have a Single instance with 10 db's on it. Its an Business critical Application running on it that y it took a long time for approval for upgrade to sql server 2005.
Now i have have a test box and i wanted the create a instance there and get bkp restored for upgrade (test purpose). And i have an instance(Already running) in the test Box.
So can Some one tell me if i can one instance on sqlserevr 2000 and the other in 2005.(I am planing for IN PLACE UPGRADE)
(As i don't want to disturb the existing instance)
Thanks,
Gagan
May 11, 2009 at 6:33 am
You need to be more clear & proof read before posting.
Are you saying your test box has an SQL 2000 instance installed already and you want to also install an SQL 2005 instance on the same box?
If so, then you can, but only one can be the default instance. The other must be a named instance.
May 11, 2009 at 6:36 am
What you're proposing isn't an in-place upgrade. You're saying that you want to install 2005 on the same server as 2000 and them migrate the databases over. An in-place upgrade would simply upgrade to the 2000 instance to 2005.
You could do what you're proposing, but it's possibly a problematic approach. Your server will need to share resources between 2000 and 2005 while you do the upgrade. That might cause problems. If you can test the approach on a different server before you do it, I'd strongly recommend it.
Make sure you've got the Upgrade Advisor and you run all your databases through it.. Also, you should track down the Upgrade Assistant. I've used to it to good effect.
Finally, a question. Why, go to 2005 when 2008 is out, stable, service packed, and much earlier in it's life cycle than the four year old 2005. I wouldn't recommend a 2005 upgrade for any systems I manage at this point in time. I'd go straight to 2008.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 12, 2009 at 7:17 am
Sorry...Grant!! In between i also spoke about Dev box and some confusion casused.
But thnx for all advices..But what bothers for SQL SERVER 2008 is the fact is budget, i had Sugessted the Business about it too
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply