i'm trying to make a replication work, i've done everything but the initial
snapshot takes too long to generate (the database size is like 20 GB).
I made a backup of the database and restored it in the suscription server,
and then configured the replication. I thought that as both databases were
the same, there wouldn't be any "big" initial snapshot" but there is, and
it's very big...
how can i setup a replication having both databases with the same data and
tables and everthing, with no initial snapshot (ie. not copy tables and the
data in those tables, cos i don't need it) ?
well, thanks for reading me.
:-)Take a look at this link, you may want to initialize your subscription
without a snapshot which looks like what you are looking for.
http://msdn2.microsoft.com/en-us/library/ms151705.aspx
You better send your posts related to Replication to sqlserver.replication
NG rather than others. You get better answers there.
--
Ekrem Ã?nsoy
"DarthSidious" <DarthSidious@.discussions.microsoft.com> wrote in message
news:3DF8C352-2A09-487C-A8A5-6AD389101062@.microsoft.com...
> i'm trying to make a replication work, i've done everything but the
> initial
> snapshot takes too long to generate (the database size is like 20 GB).
> I made a backup of the database and restored it in the suscription server,
> and then configured the replication. I thought that as both databases were
> the same, there wouldn't be any "big" initial snapshot" but there is, and
> it's very big...
> how can i setup a replication having both databases with the same data and
> tables and everthing, with no initial snapshot (ie. not copy tables and
> the
> data in those tables, cos i don't need it) ?
> well, thanks for reading me.
> :-)
No comments:
Post a Comment