?
Solved

Creating a new instance of MS SQL server

Posted on 2004-09-10
3
Medium Priority
?
677 Views
Last Modified: 2012-05-05
Greetings. I would like to ask you guys on how to create a new instance of sql server.

i have a ms sql2000 server on a windows 2000 advance server. our it consultant before created an instance on that server. Now, i would like to add a new instance on that same server. how?
0
Comment
Question by:elatagaw
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 10

Accepted Solution

by:
AustinSeven earned 500 total points
ID: 12024505
Just run SQL Server installation setup on the server and you will see an option something like 'new instance'.    It really is as simple as that.    You will need to restart the server after the install.  

You should make sure there are enough resources on the server to deal with another instance.   You should also throttle back the max memory setting in each SQL Server instances' properties.   Otherwise each instance will compete.  Also leave enough RAM free for the operating system.

AustinSeven
0
 
LVL 5

Assisted Solution

by:perezjos
perezjos earned 500 total points
ID: 12039938
Hello,

Please visit this web site and read the article.


http://doc.ddart.net/mssql/sql2000/html/architec/8_ar_cs_9i5u.htm

Jose
0
 
LVL 1

Author Comment

by:elatagaw
ID: 12071509
Thank you guys. That really help me here.

More power.
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question