Monday, February 20, 2012

Log Shipping - Move DB Changes?

I am in a 2 Database shop (DB2 and SQL Server) in which one of our
larger clients use Log Shipping.

We have need to tune a table on the primary server and ADDED a simple
index to a table.

Will that index be replicated down to the secondary server via log
shipping. Or do I need to stop log shipping and apply the index to the
secondary server?

Thanks in advance for the help.

Sincerely,
MikeMike:

Yes. Log shipping will move the indexes over as well.

-Dave

madzambonis@.yahoo.com wrote:

Quote:

Originally Posted by

I am in a 2 Database shop (DB2 and SQL Server) in which one of our
larger clients use Log Shipping.
>
We have need to tune a table on the primary server and ADDED a simple
index to a table.
>
Will that index be replicated down to the secondary server via log
shipping. Or do I need to stop log shipping and apply the index to the
secondary server?
>
Thanks in advance for the help.
>
Sincerely,
Mike

No comments:

Post a Comment