Solved

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

Posted on 2012-03-29
7
236 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
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

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server - Sum Decimal Columns 11 33
Addition to SQL for dynamic fields 6 38
any adverse effect when modifying data type on a busy table. 4 13
sql how to count case when 4 16
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…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

777 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