Monitor server

I plan to create a Monitor server to monitor tasks. My goal is to avoid
using the data servers (5 servers) to perform tasks.
Some of the tasks are log shipping, generate reports, run batch file and add
users.
What is some to the drawback of using the Monitor Server?
Can Monitor Server managing users from other servers?
Any suggestions would be greatly apprecated,
Culam
"culam" <culam@.discussions.microsoft.com> wrote in message
news:D1A477E7-B9BB-4558-A8C2-A4F04D377832@.microsoft.com...
> I plan to create a Monitor server to monitor tasks. My goal is to avoid
> using the data servers (5 servers) to perform tasks.
> Some of the tasks are log shipping, generate reports, run batch file and
add
> users.
> What is some to the drawback of using the Monitor Server?
> Can Monitor Server managing users from other servers?
> Any suggestions would be greatly apprecated,
> Culam
>
|||It is better to have a monitor server which is independent of the production
servers it is monitoring...That's good.
There is no Microsoft single interface which will allow you to add users to
multiple servers, if that is what you are asking for... You could write your
own sp or interface, but I think there are probably some 3rd party tools
which may do this for you... ( Embarcadero used to have a tool for DBAs
which did this kind of thing.)
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"culam" <culam@.discussions.microsoft.com> wrote in message
news:D1A477E7-B9BB-4558-A8C2-A4F04D377832@.microsoft.com...
> I plan to create a Monitor server to monitor tasks. My goal is to avoid
> using the data servers (5 servers) to perform tasks.
> Some of the tasks are log shipping, generate reports, run batch file and
add
> users.
> What is some to the drawback of using the Monitor Server?
> Can Monitor Server managing users from other servers?
> Any suggestions would be greatly apprecated,
> Culam
>