Prev: Snapshot Location
Next: ogical consistency-based I/O error
From: Yanick Mongeau on 15 Jan 2010 13:25
Hi,

I set up transactional replication between two databases. When I applied the
generated snapshot to the subscriber, I realized that the indexes were
re-created but the WITH (FILLFACTOR=90) were missing in the indexes
definitions.

In the publication, I configured the "Copy clustered indexes" and "Copy
nonclustered indexes" article properties to True. The "Replicate schema
changes" subscription option has been set to False.

Any ideas on how to have indexes re-created with the FILLFACTOR?

Thanks in advance,
Yanick
From: Hilary Cotter on 15 Jan 2010 13:51
I would not replicated non clustered indexes and then create them in a post
snapshot script with the 90% fillfactor.

"Yanick Mongeau" <YanickMongeau(a)discussions.microsoft.com> wrote in message
news:9AABB45C-9000-4B6C-BA62-1F122528CDFE(a)microsoft.com...
> Hi,
>
> I set up transactional replication between two databases. When I applied
> the
> generated snapshot to the subscriber, I realized that the indexes were
> re-created but the WITH (FILLFACTOR=90) were missing in the indexes
> definitions.
>
> In the publication, I configured the "Copy clustered indexes" and "Copy
> nonclustered indexes" article properties to True. The "Replicate schema
> changes" subscription option has been set to False.
>
> Any ideas on how to have indexes re-created with the FILLFACTOR?
>
> Thanks in advance,
> Yanick

 | 
Pages: 1
Prev: Snapshot Location
Next: ogical consistency-based I/O error