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 |
|
carau2007
Starting Member
31 Posts |
 Posted - 2007-08-28 : 10:25:06
|
| Hi,I am using SQL Server 2000 SP3 Version 8.00.7.60. Can I create instances of SQL server 2000 even if it's already installed?Thanks for your help in advance! |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-08-28 : 10:31:40
|
| Hi carau2007, Welcome to SQL Team!What do you mean by "partition SQL server" please?Kristen |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-08-28 : 10:35:34
|
| partition how?what would you like to partition exactly?_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
carau2007
Starting Member
31 Posts |
Posted - 2007-08-28 : 10:36:36
|
| Can I create more than one instance of SQL server 2000 so I can have a testing environment and a live environment? |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-08-28 : 10:51:22
|
| you can have multiple instances on the same serverthey will of course be totaly separated and if you want to share data between then you'll have to set up linked servers._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
carau2007
Starting Member
31 Posts |
Posted - 2007-08-28 : 10:56:15
|
| How do I create them. SQL server is already installed. Is it too late? Or can I still create an instance? How do I do that? |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-08-28 : 11:02:31
|
| install it once again and chose to create a named instance instead of default instance.also you might have to consider licencing issues here._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
carau2007
Starting Member
31 Posts |
Posted - 2007-08-28 : 11:04:42
|
| Thank you! It's what I was looking ofr! |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-28 : 20:29:02
|
| Ensure server hardware can handle multiple instances. |
|
|
|
|
|
|
Partition SQL server