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 |
|
cmf
Starting Member
3 Posts |
 Posted - 2003-09-25 : 21:55:32
|
Hi All...I've lurked for a while and found the depth of wisdom around here astounding. Hopefully, this is an easy one.I'm running MSDE 2K on a laptop. I'd like to set up three instances - PROD, TEST and DEV. I'm fairly certain I can do this with MSDE. Problem is, I'm not sure how to. OK, I've checked BOL, I've searched MSDN - heck, I seem to remember searching this site - all to no avail. Oh, there's tantalizing references to instances, but no step-by-step instructions.The reason I want to do this is so I can isolate the environments in case I need to bounce the instance ('cause I write such good code  ), but more importantly, it'll help me understand the product a little better from an admin. standpoint.Anyway, in my travels, I came across sp_addserver and sp_addlinkedserver. Do I go to the master db in QA, enter the required arguments and then register the new server from within EM?Any help would be greatly appreciated.ThanksMikePS At the risk of stepping outside the bounds, what's with all the references to Yaks? |
|
|
JohnDeere
Posting Yak Master
191 Posts |
Posted - 2003-09-25 : 23:27:54
|
| New instances are created by installing SQL server again.Lance Harra |
 |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
|
|
cmf
Starting Member
3 Posts |
Posted - 2003-09-26 : 12:29:29
|
| Thanks Lance.Can I assume I can name the instance at the time of re-installation? My first install resulted from automagically loading .Net, so I'm thinking it loaded with a default server\instancename - ie, I wasn't given the opportunity to name it. AndrewThanks for the info on the Yak. Interesting mascot. Had no idea their diet included Chicken Vindaloo <grin>.Mike |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-26 : 12:59:12
|
quote:
Originally posted by cmf
Thanks Lance.Can I assume I can name the instance at the time of re-installation? My first install resulted from automagically loading .Net, so I'm thinking it loaded with a default server\instancename - ie, I wasn't given the opportunity to name it. AndrewThanks for the info on the Yak. Interesting mascot. Had no idea their diet included Chicken Vindaloo <grin>.Mike
Tara |
|
|
|
|
|
|
|
|
Instances