SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Partition SQL server
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

carau2007
Starting Member

31 Posts

Posted - 08/28/2007 :  10:25:06  Show Profile  Reply with Quote
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!

Edited by - carau2007 on 08/28/2007 10:51:32

Kristen
Test

United Kingdom
22403 Posts

Posted - 08/28/2007 :  10:31:40  Show Profile  Reply with Quote
Hi carau2007, Welcome to SQL Team!

What do you mean by "partition SQL server" please?

Kristen
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11750 Posts

Posted - 08/28/2007 :  10:35:34  Show Profile  Visit spirit1's Homepage  Reply with Quote
partition how?
what would you like to partition exactly?

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

carau2007
Starting Member

31 Posts

Posted - 08/28/2007 :  10:36:36  Show Profile  Reply with Quote
Can I create more than one instance of SQL server 2000 so I can have a testing environment and a live environment?

Edited by - carau2007 on 08/28/2007 10:41:45
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11750 Posts

Posted - 08/28/2007 :  10:51:22  Show Profile  Visit spirit1's Homepage  Reply with Quote
you can have multiple instances on the same server

they 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 1980
blog: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

carau2007
Starting Member

31 Posts

Posted - 08/28/2007 :  10:56:15  Show Profile  Reply with Quote
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?
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11750 Posts

Posted - 08/28/2007 :  11:02:31  Show Profile  Visit spirit1's Homepage  Reply with Quote
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 1980
blog: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

carau2007
Starting Member

31 Posts

Posted - 08/28/2007 :  11:04:42  Show Profile  Reply with Quote
Thank you! It's what I was looking ofr!
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 08/28/2007 :  20:29:02  Show Profile  Reply with Quote
Ensure server hardware can handle multiple instances.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000