Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-14 : 10:37:19
|
| Rahim writes "Hello there.My colleagues and I are baffled about this question.We are implementing a Master/Target server environment using a 5 servers to adminster about 400 target servers on SQL Server 2000.Each time a new target server is registered by the master server, where is that information kept? Initial investigations suggest that the information is stored in the registry.The reason for this question is for DR purposes. We have suggested ghosting the Master server when there have been a number of servers registered so if there was ever a disaster and the server was lost, it could easily be brought back to a state in which it can perform the required tasks rather than having to build the server from scratch.Also in this environment, the application database (on the 400 target server) are Binary and another 33 servers databases are normal. Will EM on any of the master servers be able to handle this? Would it be more advisable to have another Master server installed to take care of the administration of the 33 'normal' servers?Thanks for your helpRahim Kassam" |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-06-14 : 11:39:27
|
| There is a systargetservers and systargetservergroups tables in the msdb database... I would think the information you are looking for is stored there. (Not 100% sure though) |
 |
|
|
|
|
|
Enterprise Manager in a Master/Target server environment