• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 265
  • Last Modified:

Two many SQL Instances

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
TRACEYMARY
Asked:
TRACEYMARY
  • 2
2 Solutions
 
Aneesh RetnakaranDatabase AdministratorCommented:

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


Aneesh R!
0
 
imran_fastCommented:
>>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
 
TRACEYMARYAuthor Commented:
did not think so....................cheers
0
 
TRACEYMARYAuthor Commented:
I got ever server linked also and replication...all over place
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now