You are here: Re: Log Shipping - Move DB Changes? « MsSQL Server « IT news, forums, messages
Re: Log Shipping - Move DB Changes?

Posted by dmarkle on 01/13/07 17:13

Mike:

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

-Dave


madzambonis@yahoo.com wrote:
> 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

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация