Solved

can you save 'registered servers' and take it to another workstation?

Posted on 2012-03-29
7
234 Views
Last Modified: 2012-04-03
I have saved all the registered servers in one workstation for sql server r2.

can i somehow save this and take it to another workstation and bring it up there without having to register each one again?
0
Comment
Question by:25112
  • 3
  • 2
  • 2
7 Comments
 
LVL 29

Accepted Solution

by:
Paul Jackson earned 250 total points
ID: 37781790
They are kept as an XML document here:

C:\Documents and Settings\username\Application Data\Microsoft\Microsoft SQL Server\100\Tools\Shell\RegSrvr.xml

you can copy the file to the other workstations
0
 
LVL 25

Assisted Solution

by:TempDBA
TempDBA earned 250 total points
ID: 37782786
Better you create a central management server. This is a new feature which will help you centralize you registered servers and update it in all hosts whenever it gets modified. Check out the following link:-
http://msdn.microsoft.com/en-us/library/bb934126.aspx
0
 
LVL 5

Author Comment

by:25112
ID: 37787076
jacko72, can you move the xml between 2005 and 2008 servers?
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 5

Author Comment

by:25112
ID: 37787084
TempDBA, that concept is to only run a same query is so many servers at one time, right? can you use it to transfer from one workstation to another?
0
 
LVL 29

Expert Comment

by:Paul Jackson
ID: 37787312
0
 
LVL 25

Expert Comment

by:TempDBA
ID: 37787489
No, you can't. But all the workstations that can access the servers can connect to the central management server.
-Go to view -> Registered Servers -> Database Engine -> Central Management Servers ->Register Central Management Server -> Type the name -> And there you go.

So, basically its same as registered server, but the only difference is everyone doesn't need to make there local copy. A centralized one will do. And handling is also easy as all the reference tables are there in msdb database. So, it will be pretty easy.

Coming back to your exporting of the registered server, you can right click on the registered server -> task -> export.
Then in the other computer, you can do import in a similar fashion.
0
 
LVL 5

Author Comment

by:25112
ID: 37801941
thank you Sirs..
0

Featured Post

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

706 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

16 Experts available now in Live!

Get 1:1 Help Now