Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multiple Instances

Status
Not open for further replies.

billmay

Programmer
Apr 4, 2001
24
AU
I believe its possible to run multiple instances of MSSQL on the same server

What are the pros and cons of this ? as distinct to just running multiple databases
 
A server box can coexist SQL 6.5 ,SQL 7 and SQL 2000.You should first install SQL 6.5 then latest Service pack for 6.5 --> SQL 7 then latest Service pack for 7 -->SQL2000 Then latest Service Pack for it.

You can have one SQL 6.5 running
You can have one SQL 7.0 running
You can have multiple instance SQL 2000 running,SQL 2000 can run as named instance but not for 6.5 and 7.0

You can switch between 6.5 and 7.0 by SQL SErver Switch


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top