Showing posts with label initial. Show all posts
Showing posts with label initial. Show all posts

Tuesday, February 21, 2012

Replication: Synchronization Status

In SQL 2005 when i expand the local publication , Under replication when i try to view Synchronization Status i see the below message.

The initial snapshot for publication '%Database' is not yet available.

can any one help me on this issue.

Thanks

You can open the replication monitor, go under this publication, go to the other agents tab, and start snapshot.|||This is because initial snapshot for the publication has not been generated. So generate snapshot first.

Replication: Initial snapshot takes too long

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.
> :-)