RE: Replication

From: Robert Davis (RobertDavis_at_discussions.microsoft.com)
Date: 12/02/04 

Date: Thu, 2 Dec 2004 08:01:05 -0800

1. Correct. Usually so that it can be accessed by different applications.
2. Snapshot replication copies over the entire database. So if the db's are
big, the snapshots will be big.
3. No!! Perish the thought!!! Okay, that was a bit melodramatic, but you
will still need to backup the main instance of the database(s).
4. I don't have any recommendations.

"Chris Marsh" wrote:

> I am posting a rather general question here regarding "Replication". I have
> a client (actually many clients) where it would be nice if they can
> replicate their live database to my server in the event of power outage,
> server troubles, general backup, etc. I have played around with it but not
> with much luck a while back. Real-time backups would be amazing but a daily
> backup or snapshots multiple times a day would also work just fine.
>
> 1 - I assume that the entire idea of Replication is exactly this, keeping
> live databases in multiple locations - correct?
> 2 - Are there big bandwidth performance hits when using replication?
> 3 - Does replication somewhat replace backups?
> 4 - Are there any good books or samples that someone could suggest? I know
> BOL has examples.
>
> Thank you for the general assistance in advance. I have received excellent
> assistance over the past few months on this newsgroup learning and
> implementing our SQL projects.
>
> Chris
>
>
>

Relevant Pages

  • Re: Backup Structure Only
    ... I sometimes need to backup a database in one location andcomparethe ... have a look at xSQL Software's xSQL Object - it ... You can then compare snapshots to live databases or snapshots ...
    (comp.databases.ms-sqlserver)
  • Replication and filegrowth
    ... After setting up replication of a database the ... Due to the developing phase the database backup set i often downloaded ... There has been set up an initial snapshot replication and a merge ...
    (microsoft.public.sqlserver.replication)
  • RE: How do I restore from mdf and ldf files?
    ... Tasks -> Backup Database ... Tasks -> Restore Database ... Windows 2003 Server with Latest Service Pack ... Pre-requisites for Sharepoint Backup and Restore: ...
    (microsoft.public.sharepoint.portalserver)
  • Re: RMAN restore of full backup fails completely
    ... You are not using a catalog database. ... You might have autobackup controlfile on, ... Your autobackup has been made *prior* to the backup! ... plus archivelog', when i try a restore on the other server however, the ...
    (comp.databases.oracle.server)
  • Backup and Restore Files
    ... What is the best way to backup and restore a runtime database file? ... pszDisplayName As String ...
    (microsoft.public.access.gettingstarted)