|
Home > Archive > microsoft.public.sqlserver.server > August 2002 > managing multiple databases on many servers
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
managing multiple databases on many servers
|
|
| Heather Allemang 2002-08-06, 5:23 pm |
| Hello,
I manage many SQL servers and would like to acquire the
best method to centralize this process. I work in an
environment where the servers continually need to be
cleaned, and I would like to be able to monitor from one
console if possible all the databases and their owners on
all the servers. Does anyone know of anything out there
that can do this?
| |
| Ron Talmage 2002-08-06, 7:23 pm |
| Heather,
If Enterprise Manager will not work for you, there are numerous third party
products that can simplify the management of many SQL Servers. Most of them
advertize in SQL Server Magazine.
To centralize maintenance, you might make use of the master/target
relationship where SQL Agent on a master server reports on jobs running on
many target SQL Agents.
Ron
--
Ron Talmage
SQL Server MVP
Heather Allemang <heathera@onyx.com> wrote in message
news:151d01c23d97$83d781d0$b1e
62ecf@tkmsftngxa04...
> Hello,
> I manage many SQL servers and would like to acquire the
> best method to centralize this process. I work in an
> environment where the servers continually need to be
> cleaned, and I would like to be able to monitor from one
> console if possible all the databases and their owners on
> all the servers. Does anyone know of anything out there
> that can do this?
>
>
|
|
|
|
|