Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
david32
Starting Member
15 Posts |
 Posted - 2008-09-18 : 22:56:13
|
| 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? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-18 : 23:03:28
|
| Why you need to create test instance on production server? Just Apply SP2 and recent build on it as it will be cumulative. |
 |
|
|
david32
Starting Member
15 Posts |
Posted - 2008-09-18 : 23:35:49
|
| I need to create a test instance on the production server because it is the only server out on our DMZ. The test database needs to be on the DMZ as well according to our network admin. The production box is all we have in the DMZ. I have been asked not to install any patches on the production instance until the patches have been tested in a development environment. |
|
|
|
|
|
|
instances on different patch level on a server