March 5, 2008 at 10:09 am
We have a default instance and a named instance of sql 2000 on a box. We are planning to just upgrade the named instance first and do the default at a later date for business reasons.
I believe the default instance should not be affected and the databases should be working while we upgrade the named instance. Am I right or wrong?
Thanks
KR
March 5, 2008 at 10:21 am
You are correct, it should not be a problem just updating the named instance. however make sure you take a full backup of all your databases on both instances - just in case!
March 5, 2008 at 10:23 am
should be doable.
may I emphasize you need to start with SQLServer upgrade advisor.
It checks your sql2000 sb/server and will highlight issues you need to address before the move !
also keep in mind there may be unavailability (even for your default instance), so plan well !
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
March 5, 2008 at 2:10 pm
We have run the upgrade Advisor and working with the vendor that provides the application to resolve any issues that need to be addressed.
One more question - this box also has sql server express installed on it - would that cause a problem? Again I would not think so, but just wondering if anyone had issues that we need to be aware of?
Thanks
KR
March 5, 2008 at 2:18 pm
Karthika Raman (3/5/2008)
We have run the upgrade Advisor and working with the vendor that provides the application to resolve any issues that need to be addressed.One more question - this box also has sql server express installed on it - would that cause a problem? Again I would not think so, but just wondering if anyone had issues that we need to be aware of?
Thanks
KR
Should not be an issue, but if you're not using it ... you should remove it, or at least shut it down to conserve system resources.
March 5, 2008 at 2:21 pm
Thanks much!
Not to sound paranoid, my original question was especially referring to the availabilty of the default sever availability DURING the upgrade of the named instance. I believe you all answered me in that it would be available during upgrade, but just want to confirm
Again thank you all for your help
KR
March 6, 2008 at 8:56 am
I've had some issues applying the servicepacks (and you need to apply at least sp2 + cu2 (cu5 or 6 if you can)) on client installations having SQLExpress installed during the visual studio 2005 setup.
Didn't pay much attention for it, because the instances were unused, so I uninstalled them and continued with the sp installs.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply