September 18, 2008 at 8:51 pm
Hi Folks,
I have a SQL 2005 Standard 32 bit instance that is on the RTM release (1399). I cannot patch it now as it is a production box I have inherited and staff that use it want to test the patch level on a test database before releasing it to prod.
To create a test environment I want to install another instance on the same server and update it to (9.0.3073). Can I update this instance and still leave the production one on 1399?
September 18, 2008 at 9:02 pm
Possibly. Not sure if that patch hits shared components or not.
Why not setup a separate instance on another test machine, or even in a VM? I wouldn't gamble with production.
September 18, 2008 at 9:49 pm
Considering I will need to install SP2 to install it - I think it would. Which are the component that are shared? - perhaps the current instance does not have them. If I configured the instance for different IP would it still regard shared components are shared?
September 19, 2008 at 12:32 pm
I wouldn't put another instance on a production box in the first place.
September 19, 2008 at 1:00 pm
- You'd indeed be better off putting your test instance at another server (not on your production box)
- You may even consider installing a developer edition (not that $$)
- If you install another instance on your production box, keep in mind that it will upgrade the shared objects to sp2 and you may even need to reboot the server !!
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 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply