Solved

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

Posted on 2012-03-29
7
237 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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

809 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