Re: Transactional Replication

From: Kyle Jedrusiak (kjedrusiak_at_princetoninformation.com)
Date: 03/01/05 

Date: Tue, 1 Mar 2005 15:21:09 -0500

I've read several of the pages on your website and it's still not completely
clear.

Here is the full scenario which is probably typical...

We have an accounting database. We didn't develop it and we have no control
over the schema (including view, SPs, etc)

We would like to be able to (manually) fail over to a server in a different
city in a reasonable amount of time while (of course) losing little or no
data.

Once we have whatever it is set up there should be little to do unless we DO
need to fail over. Could or would it be as simple as pointing to a server
with a different ip address.

Kyle!

"Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message
news:Ow8K8dpHFHA.576@TK2MSFTNGP15.phx.gbl...
> Kyle,
> transactional replication and log shipping have both been used for this
> sort of thing. Log shipping is usually the more appropriate, but have a
> look here for a high-level comparison:
> http://www.replicationanswers.com/Standby.htm
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>

Relevant Pages

  • Re: Need Feedback on Trans. Replication w/ Remote Distributor
    ... Built-in log shipping works over SMB protocols. ... BOL describes the built-in stuff for Log Shipping in Enterprise ... The SQL 2000 resource kit has some more information on roll your ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.replication)
  • Re: SQL 2005 servers with multiple instances
    ... log shipping is the current plan. ... given the same number of user databases. ... server, one old server, many new drives) and we spec'ed it for SQL2000's ... has changed since I worked with it, clustering only has one copy of the ...
    (microsoft.public.sqlserver.setup)
  • Transaction Log Shipping silently fails?
    ... I configured SQL2005 transaction log shipping from a primary to a secondary server. ... I created shares on the primary and secondary, and configured log shipping on the primary with the default options, with the dB on the secondary set to "standby" during log restores. ... The database is about 5 gig, so I did a separate restore on the secondary before configuring shipping. ...
    (microsoft.public.sqlserver.tools)
  • Re: Disaster recovery - Use Replication or Log shipping
    ... cons of each ... Pros log shipping ... there is a log shipping wizard that ships with SQL 2000 EE, ... standby server database must go off line as you apply the tlogs ...
    (microsoft.public.sqlserver.replication)
  • Re: newbie help: failover server
    ... I will look into Log Shipping & the SQL Resource ... As far as business decision vs technology decision, ... > Server 2000 Resource Kit includes a simple log shipping example that you ...
    (microsoft.public.sqlserver.clustering)
Loading