Re: on-line and near-line databases

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



One way to achieve this is to use transactional replication and select to
not replicate deletes (NONE for the command).
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com


.



Relevant Pages

  • Re: 2 way replication.
    ... updatable transactional replication might be more relevant. ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Re: 2 way replication.
    ... updatable transactional replication might be more relevant. ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Re: Log Shipping - dumb question
    ... this reason some people use transactional replication instead. ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Re: Order of replication flow
    ... for transactional replication, ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Re: Whats the best replication model I can implement?
    ... transactional replication. ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)