Two many SQL Instances

Posted on 2006-07-15
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

Question by:TRACEYMARY
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
  • 2
LVL 75

Assisted Solution

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

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

Aneesh R!
LVL 28

Accepted Solution

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.

Author Comment

ID: 17114712
did not think so....................cheers

Author Comment

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

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

623 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