March 30, 2009 at 11:56 am
Hi All,
I have a query.
If we reinitialize the replication will the indexes be dropped on the subscriber?
Recently we had re-initialized the replication for some reason and after that we noticed that the indexes on the tables of the subscriber were missing.
We have the indexes on the articles at the publisher end.
Is this a normal behavior or something went wrong.
Thanks,
Sandhya
March 30, 2009 at 2:58 pm
if you did not specified index creation on the schema_option of your table articles the indexes will not be replicated.
* Noel
March 30, 2009 at 5:27 pm
Here's the schema_option value I use in my setup - hope it's helpful
SET @schema_opt = 1 | 2 | 16 | 32 | 64 | 128
/*
0x01 Generates the object creation script
0x02 Generates the stored procedures that propagate changes for the article, if defined.
0x10 Generates a corresponding clustered index
0x20 Converts user-defined data types (UDT) to base data types at the Subscriber
0x40 Generates corresponding nonclustered indexes
0x80 Replicates primary key constraints
*/
Which translates to 0x00000000000000F3. Details are documented here http://msdn.microsoft.com/en-us/library/ms173857(SQL.90).aspx
March 31, 2009 at 1:47 pm
Well that is correct if you want the index generated. So I can on take another "guess":
There is also another place to check. If the table articles are not marked as "drop" and someone or something removed the indexes they would not be recreated.
* Noel
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply