索引将自动从Sql DB中删除。可能吗？ [英] Indexes are removed automatically from Sql DB. Is it possible?

问题描述

我不是数据库人。



有一个数据库（A）存储在sql server 2008R2中。从数据库（A）复制到其他数据库（B），存储在同一位置。索引将自动从（B）中删除。它每天发生两次。有可能吗？



我已经多次搜索但没有得到满意的答案。请帮助..

Hi,

I am not a DB guy.

There is a database(A) stored in sql server 2008R2. There is a replication to other database(B) from Database(A), stored at the same place. Indexes are being removed from (B) automatically.It happens two times a day. Is it possible?

I have searched many times but not get a satisfactory answer. Please help..

推荐答案

是删除所有索引还是只删除非群集索引？

可以是schema_option是设置为复制非聚簇索引 = false？



请查看这篇文章：

http://blogs.msdn.com/b/repltalk/archive/2012/ 04/03 / replicating-non-clustered-indexes-improve-subscriber-query-performance.aspx



和这个msdn论坛问题：

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/51512117-b53d-429b-8c3d-84d9a925126e/sql-server-replication-initilize-subscription-removes-nonclustered-indexes?forum=sqlreplication



希望这会有所帮助。

Does all the indexes are being removed or just the non clustered ones?
Can it be that the schema_option is set to "copy nonclustered indexes" = false?

please review this article:
http://blogs.msdn.com/b/repltalk/archive/2012/04/03/replicating-non-clustered-indexes-improves-subscriber-query-performance.aspx

and this msdn forum question:
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/51512117-b53d-429b-8c3d-84d9a925126e/sql-server-replication-initilize-subscription-removes-nonclustered-indexes?forum=sqlreplication

hope this will help.

这篇关于索引将自动从Sql DB中删除。可能吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！