Solved

Two many SQL Instances

Posted on 2006-07-15
4
224 Views
Last Modified: 2012-06-21
We have say 15 instances of SQL all other different servers all on different sp etc and data all over different servers some data on SAN

And i installed another 2 copies of SQL last week.

Is there a way to just have one copy of SQL...............and virtualize it.......

Anyone in same boat..............and have a better way of doing this....

I can see in a another year it be up to 30


0
Comment
Question by:TRACEYMARY
  • 2
4 Comments
 
LVL 75

Assisted Solution

by:Aneesh Retnakaran
Aneesh Retnakaran earned 250 total points
ID: 17114206

TRACEYMARY,
> Is there a way to just have one copy of SQL...............and virtualize it.......
No,


Aneesh R!
0
 
LVL 28

Accepted Solution

by:
imran_fast earned 250 total points
ID: 17114276
>>Is there a way to just have one copy of SQL...............and virtualize it.......
No as aneesh said but you can have link server and replication if you want to centralize data.
0
 
LVL 7

Author Comment

by:TRACEYMARY
ID: 17114712
did not think so....................cheers
0
 
LVL 7

Author Comment

by:TRACEYMARY
ID: 17114714
I got ever server linked also and replication...all over place
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to use odbc in vb to connect to ms sql 14 40
sql server query from excel 3 57
Help with SQL Server Stoplist 2 21
Update data using formula 22 23
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

863 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now