no sync workaround

sql2k
I need to do replication of a between 2 buildings 30 miles apart with 1 T1.
I read about the nosyn method in
http://support.microsoft.com/default...b;en-us;320499
but the hangup Im having with this is putting the DB into Single User Mode.
I see the logic here, but this sucks. Any way to do nosync without using
SUM? A way to start replication using nosync but have it queued up until I
get the box and db at the subscriber up and running?
TIA, ChrisR
the short answer is no.
In such environments I have backed up the database, restored it on the
subscriber, fixed the schema (all constraints are made not for replication,
fixed the identity keys, dropped cascading updates and deletes, made
triggers not for replication, etc), and then done my no sync. I use the
continue on data consistency errors, and patched the subscriber to be in the
same as the publisher. Its a moving target and can be a real chore to fix.
You will need to run numerous validations.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"ChrisR" <noemail@.bla.com> wrote in message
news:uTQO799gFHA.1996@.TK2MSFTNGP10.phx.gbl...
> sql2k
> I need to do replication of a between 2 buildings 30 miles apart with 1
T1.
> I read about the nosyn method in
> http://support.microsoft.com/default...b;en-us;320499
> but the hangup Im having with this is putting the DB into Single User
Mode.
> I see the logic here, but this sucks. Any way to do nosync without using
> SUM? A way to start replication using nosync but have it queued up until I
> get the box and db at the subscriber up and running?
>
> TIA, ChrisR
>
|||I use the
> continue on data consistency errors, and patched the subscriber to be in
> the
> same as the publisher.

> You will need to run numerous validations.
What are these? I have no idea where they are.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:ud7ZdNChFHA.1444@.TK2MSFTNGP10.phx.gbl...
> the short answer is no.
> In such environments I have backed up the database, restored it on the
> subscriber, fixed the schema (all constraints are made not for
> replication,
> fixed the identity keys, dropped cascading updates and deletes, made
> triggers not for replication, etc), and then done my no sync. I use the
> continue on data consistency errors, and patched the subscriber to be in
> the
> same as the publisher. Its a moving target and can be a real chore to fix.
> You will need to run numerous validations.
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "ChrisR" <noemail@.bla.com> wrote in message
> news:uTQO799gFHA.1996@.TK2MSFTNGP10.phx.gbl...
> T1.
> Mode.
>
|||right click on your distribution agent, select agent profiles, and select
continue on data consistency errors.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"ChrisR" <noemail@.bla.com> wrote in message
news:OTLkZFJhFHA.1444@.TK2MSFTNGP10.phx.gbl...
> I use the
>
> What are these? I have no idea where they are.
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:ud7ZdNChFHA.1444@.TK2MSFTNGP10.phx.gbl...
>
|||Awesome! Where do I do a validation.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OxSQsPNhFHA.3692@.TK2MSFTNGP09.phx.gbl...
> right click on your distribution agent, select agent profiles, and select
> continue on data consistency errors.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "ChrisR" <noemail@.bla.com> wrote in message
> news:OTLkZFJhFHA.1444@.TK2MSFTNGP10.phx.gbl...
>