开发者

Errors restoring a Sql Server 2008 database with Merge Replication

I'm trying to restore my database from a file and get the following error:

"An explicit DROP INDEX is not allowed on index..." "It is being used for PRIMARY KEY constraint enforcement."

If I delete the primary key and create a new backup it restores fine.

Unique things about the primary key: --It is on a GUID with default NEWSEQUENCIALID() --It is used for merge replication

Some tables with identical primary key structures are rest开发者_StackOverflowored just fine. But there are 2 tables that result in the above error when I set the primary key.


I know this is a 4 months old anwer but somebody might find it useful. I had the same issue restoring a .bak file of a database with merge replication, you need to go to options and check the "WITH KEEP_REPLICATION" option, then restore your database as usual. The restore process shall success.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜