Creating Test and Prod env on SQL server 2K

Question

Creating Test and Prod env on SQL server 2K

Rashmin Amin

Valued Member

Points: 50
More actions
May 19, 2006 at 11:35 am

#103165

I am new to SQL server, (I been in Oracle world). I been asked to create a test server registration on the same sever that hosts the Prod SQL server (consisting multiple DBs). How do I do this? Or is it possible at all? Any help is appreciated.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Aaron Ingold SSCrazy Eights Points: 9070 More actions · Answer 1

If you want to put it on the same physical box you'll need to probably install a second instance. When you go through the SQL installation process, it will ask you to do default or named instance. You can have one default instance (which will be accessed at SERVERNAME), and several default instances (which are named with the scheme: SERVERNAME\INSTANCENAME).

Rashmin Amin Valued Member Points: 50 More actions · Answer 2

Thanks Aaron. I will try this out. I guess the current install that they have created is default, as it is refered as "local" on the physical box. Is there a way to create another instance without going through the whole install process?

Hrudhay Say Hey Kid Points: 668 More actions · Answer 3

I would say No to your Query,

You should install the another instance with all the binaries.

Rashmin Amin Valued Member Points: 50 More actions · Answer 4

Thanks Hrudhay . I have created another instance with all the binaries.

Thanks to all who responded to my question, I deeply appreciate your help and time.