Re: Log Shipping

From: "Paul Ibison" <Paul.Ibison@xxxxxxxxxxxxx>
Date: Fri, 10 Feb 2006 20:07:21 -0000

Anthony,
there's loads on the web about log-shipping eg
http://www.sql-server-performance.com/sql_server_log_shipping.asp
http://support.microsoft.com/default.aspx?scid=kb;en-us;323135&sd=tech
The monitoring server is a third server or the standby, simply because if it was the primary server and that went down, there would be no more monitoring :)
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Follow-Ups:
- Re: Log Shipping
  - From: ANTHONY SHEEHAN

References:
- Log Shipping
  - From: ANTHONY SHEEHAN
- Re: Log Shipping
  - From: Paul Ibison

Prev by Date: Re: Advice Needed: Asynchronous Replication/Mirroring to central o
Next by Date: Re: Log Shipping
Previous by thread: Re: Log Shipping
Next by thread: Re: Log Shipping
Index(es):
- Date
- Thread

Relevant Pages

Re: Failed to connect to server Microsoft.SqlServer.ConnectionInfo for database mirroring
... asynchronous mirroring with MS SQL Server 2008 as the primary server ... and MS SQL Server Express 2008 as the mirror server. ... The mirror server can connect to the primary server, ...
(microsoft.public.sqlserver.connect)
Failed to connect to server Microsoft.SqlServer.ConnectionInfo for database mirroring
... asynchronous mirroring with MS SQL Server 2008 as the primary server ... and MS SQL Server Express 2008 as the mirror server. ... The mirror server can connect to the primary server, ...
(microsoft.public.sqlserver.connect)
Re: Log shipping: When Standby server fails, will primary continue?
... The primary server will be fine. ... Jasper Smith (SQL Server MVP) ... > We are about to set up a log shipping solution using SQL ...
(microsoft.public.sqlserver.security)
Re: Replication to establish warm Standby
... Transactional replication can be used for the purpose you want. ... caution that replication appears to be one of the SQL Server more ... server if your primary server goes down for any reason. ... order to allow your users to access it as if it were your primary server. ...
(microsoft.public.sqlserver.server)
Log Shipping, Failover, and a named instance of SQL Server
... I plan to use SQL SErver 2k EE for logshipping on a couple of sql server ... primary server is unavailable for an extended time. ... then handling redirection of the clients to the secondary server seems ...
(microsoft.public.sqlserver.setup)