Re: Log Shipping Monitor server - has to be own server ?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 05/24/04


Date: Mon, 24 May 2004 12:51:48 -0400

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.
>
>


Relevant Pages

  • Re: Replication Architecture/Design advise
    ... >you do not need the Enterprise Edition of SQL Server for log shipping. ... >If you choose to use replication - I would use bi-directional transactional ... the standby server and will only be used when the primary fails. ...
    (microsoft.public.sqlserver.replication)
  • Re: load balancing question
    ... get log shipping. ... Search MSDN, Google, and some of the popular SQL Server web sites for log ... > have the standby server pickup automatically and then I can work on ...
    (microsoft.public.sqlserver.server)
  • SQL 2000 Standard Edition : Log Shipping copy problem..
    ... database backup has been transferred and restored to the ... standby server and log shipping is set up, ... and then set up log shipping from scratck while ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Very Urgent
    ... I am facing one problem regarding the Log shipping issues. ... Production Server and the Second server called as a Standby Server. ...
    (microsoft.public.sqlserver.clients)
  • Re: URGENT! URGENT!
    ... ANyways I tried another monitor ... No luck either. ... "Shane Daniels" wrote in message ... >> Server Splash Screen and then all I get is a BLANK SCREEN and nothing. ...
    (microsoft.public.windows.server.general)