Multi Server Administration

Hi,
We are about to implement MSX across our servers, we have some 400 SQL
Servers. What is the recommended number of master servers in sites as big as
this? Is there a maximum (recommended) number of target servers you can have
per master server?
Thanks
Julian
There is no hard recommended number that I know of. But before you
implement that you may want to check out SQL Sentry at
http://www.sqlsentry.net/ first. It can save you a LOT of headaches with
trying to monitor that many servers.
Andrew J. Kelly SQL MVP
"Julian" <Julian@.discussions.microsoft.com> wrote in message
news:0927CB87-4430-4860-9BDE-E3555B1168F7@.microsoft.com...
> Hi,
> We are about to implement MSX across our servers, we have some 400 SQL
> Servers. What is the recommended number of master servers in sites as big
as
> this? Is there a maximum (recommended) number of target servers you can
have
> per master server?
> Thanks
> Julian
|||The Quest tools for SQL Server also have multi-server execution capability.
It's similar to Query Analyzer, except that you can select as many servers
as you like to execute against. There's a freeware version too. Check out
http://www.quest.com/quest_central/s...ver/freeware/.
"Julian" <Julian@.discussions.microsoft.com> wrote in message
news:0927CB87-4430-4860-9BDE-E3555B1168F7@.microsoft.com...
> Hi,
> We are about to implement MSX across our servers, we have some 400 SQL
> Servers. What is the recommended number of master servers in sites as big
as
> this? Is there a maximum (recommended) number of target servers you can
have
> per master server?
> Thanks
> Julian

Multi Server Administration

Hi,
We are about to implement MSX across our servers, we have some 400 SQL
Servers. What is the recommended number of master servers in sites as big as
this? Is there a maximum (recommended) number of target servers you can have
per master server?
Thanks
JulianThere is no hard recommended number that I know of. But before you
implement that you may want to check out SQL Sentry at
http://www.sqlsentry.net/ first. It can save you a LOT of headaches with
trying to monitor that many servers.
--
Andrew J. Kelly SQL MVP
"Julian" <Julian@.discussions.microsoft.com> wrote in message
news:0927CB87-4430-4860-9BDE-E3555B1168F7@.microsoft.com...
> Hi,
> We are about to implement MSX across our servers, we have some 400 SQL
> Servers. What is the recommended number of master servers in sites as big
as
> this? Is there a maximum (recommended) number of target servers you can
have
> per master server?
> Thanks
> Julian|||The Quest tools for SQL Server also have multi-server execution capability.
It's similar to Query Analyzer, except that you can select as many servers
as you like to execute against. There's a freeware version too. Check out
www.quest.com/quest_central/sql_server/freeware/.
"Julian" <Julian@.discussions.microsoft.com> wrote in message
news:0927CB87-4430-4860-9BDE-E3555B1168F7@.microsoft.com...
> Hi,
> We are about to implement MSX across our servers, we have some 400 SQL
> Servers. What is the recommended number of master servers in sites as big
as
> this? Is there a maximum (recommended) number of target servers you can
have
> per master server?
> Thanks
> Julian

Multi Controller

For large databases backup the databases in to multiple backup devices
spanned across multiple disk controllers.
This will create multiple threads during backup right...
what is the command like let's assume we have three controller C: D: E:
the backup command we can write like
backup database DBName to disk = c:\DBDirectory
How can I take the backup into the multiple backup devices on the spot.
Thanks
Hi,
1. Create seperate Backup devices pointing to each controllers using
sp_addumpdevice system stored procedure.
2. Backup the database using Backup database command mentioning all the
devices
Backup database <dbname> to db1_control1,db1_control2 with Init
with init option will overwrite the backup files
Thanks
Hari
SQL Server MVP
"Rogers" <Rogers@.discussions.microsoft.com> wrote in message
news:19D4728B-E399-4E14-AE78-213371431378@.microsoft.com...
> For large databases backup the databases in to multiple backup devices
> spanned across multiple disk controllers.
> This will create multiple threads during backup right...
> what is the command like let's assume we have three controller C: D: E:
> the backup command we can write like
> backup database DBName to disk = c:\DBDirectory
> How can I take the backup into the multiple backup devices on the spot.
> Thanks
|||Just a note that you don't need dump devices to backup to multiple files.
You can specify the filename directly as well.
Andrew J. Kelly SQL MVP
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:OR1YS4qOFHA.2748@.TK2MSFTNGP09.phx.gbl...
> Hi,
> 1. Create seperate Backup devices pointing to each controllers using
> sp_addumpdevice system stored procedure.
> 2. Backup the database using Backup database command mentioning all the
> devices
> Backup database <dbname> to db1_control1,db1_control2 with Init
> with init option will overwrite the backup files
> Thanks
> Hari
> SQL Server MVP
>
> "Rogers" <Rogers@.discussions.microsoft.com> wrote in message
> news:19D4728B-E399-4E14-AE78-213371431378@.microsoft.com...
>
|||Backup database <dbname> to db1_control1,db1_control2 with Init
Is that means that the same backup will take place into two cotroller or
partially one and partially into another.
"Hari Prasad" wrote:

> Hi,
> 1. Create seperate Backup devices pointing to each controllers using
> sp_addumpdevice system stored procedure.
> 2. Backup the database using Backup database command mentioning all the
> devices
> Backup database <dbname> to db1_control1,db1_control2 with Init
> with init option will overwrite the backup files
> Thanks
> Hari
> SQL Server MVP
>
> "Rogers" <Rogers@.discussions.microsoft.com> wrote in message
> news:19D4728B-E399-4E14-AE78-213371431378@.microsoft.com...
>
>
|||Hi,
Partiall backup files will be send to each drives specified in Backup
database command
Thanks
Hari
SQL Server MVP
"Rogers" <Rogers@.discussions.microsoft.com> wrote in message
news:F17B751D-4C3D-4D1B-8294-508C4286E333@.microsoft.com...[vbcol=seagreen]
> Backup database <dbname> to db1_control1,db1_control2 with Init
> Is that means that the same backup will take place into two cotroller or
> partially one and partially into another.
>
> "Hari Prasad" wrote:
|||Thanks HARI.
"Hari Prasad" wrote:

> Hi,
> Partiall backup files will be send to each drives specified in Backup
> database command
> Thanks
> Hari
> SQL Server MVP
> "Rogers" <Rogers@.discussions.microsoft.com> wrote in message
> news:F17B751D-4C3D-4D1B-8294-508C4286E333@.microsoft.com...
>
>