Errors Restoring Sql Server 2008 with Merge Replication

Question

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

"Explicit DROP INDEX not allowed by index ..." "It is used to force the PRIMARY KEY."

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

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

Some tables with identical primary key structures are restored just fine. But there are 2 tables that lead to the above error when I set the primary key.

Answer 1

I know this is a 4 month old anwer, but someone might find this helpful. I had the same problem recovering a .bak file from a merge replication database, you need to go to the options and check the "WITH KEEP_REPLICATION" option, and then restore the database as usual. The recovery process will be successful.