Wednesday, March 21, 2012

Log Shipping Monitor server - has to be own server ?

Hi,
I see that Microsoft recommend that the monitor server isn't the source
server when using log shipping. I have 2 sql servers - 1 live and 1 standby
with which I would like to implement log shipping. Do I therfore need to buy
a seperate server for monitoring the log shipping ?(!) or can I use the
standby server ?
Thanks,
Shane.No, a third server is not required.
--
Andrew J. Kelly
SQL Server MVP
"Shane Daniels" <shanedaniels101@.yahooo.com> wrote in message
news:Ox1RdXaQEHA.1048@.tk2msftngp13.phx.gbl...
> Hi,
> I see that Microsoft recommend that the monitor server isn't the source
> server when using log shipping. I have 2 sql servers - 1 live and 1
standby
> with which I would like to implement log shipping. Do I therfore need to
buy
> a seperate server for monitoring the log shipping ?(!) or can I use the
> standby server ?
> Thanks,
> Shane.
>

No comments:

Post a Comment