Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Two many SQL Instances

Posted on 2006-07-15
4
Medium Priority
?
262 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 1000 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 1000 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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
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.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

916 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