Re: SQL replication
Tech-Archive recommends: Fix windows errors by optimizing your registry
On Thu, 4 Aug 2005 13:09:04 -0700, "SQL_Newbie"
<SQL_Newbie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>Is it possible to use a backup copy of a database in SQL to create
>replication instead of using a snapshot??
Yes.
Kick all users off both publisher and subscriber. Take backup. Ship
backup. Restore backup. Start replication. Allow users back on both
systems.
You may want to script out the entire replication process and run from
the scripts instead of from EM in order to maintain proper control
over all the steps, but it works fine.
The total replication with snapshot system is very capable and allows
you to establish replication even if either or both publisher and
subscriber are 24x7, but if you have the luxury of shutting down
operations for an hour or so, you can use backups instead of
snapshots, which I found many times faster.
Josh
.
Relevant Pages
- Re: Event id 2042 /2041 (Directory service) + 12292/11 (VSS)
... on all DC's except FSMO role holder and then promote one DC. ... take system state backup or even any file backup using it. ... Error returned while creating the volume shadow copy:0x8004230f. ... created by loss of replication. ...
(microsoft.public.windows.server.active_directory) - Re: Replication from one SQL2000 to another SQL2000
... separate snapshot publication, and run this after your initial snapshot has ... Looking for a SQL Server replication book? ... I setup a replication from one SQL 2000 server to another. ... but is there right after I ran a script. ...
(microsoft.public.sqlserver.replication) - Re: Incorrect table Definitions
... > any differently than when you use Enterprise manager's script generating ... On the Publisher or subscriber? ... >> Looking for a SQL Server replication book? ... >>> new snapshot and then it seems to see the new columns. ...
(microsoft.public.sqlserver.replication) - Re: Error building replication through scripts
... Publication Wizard, even though I am setting the name ... IDENTITY property and the NOT FOR REPLICATION option. ... this action before the snapshot is applied. ... custom script, create the publication, create the script, ...
(microsoft.public.sqlserver.replication) - Re: Replicating Windows Server 2003 to create remote backup server
... changes, as you can with any replication, but in your case that does not ... So, if we had a replica server, for backup ... Each of those services needs a recovery plan, ...
(microsoft.public.windows.server.general) |
|
