Tag: sp_dropsubscription

Restore of Replicated Database fails with “Cannot drop the table because it is being used for replication.”

Sateesh Yele Microsoft SQL Server Support Issue: Restore of a replicated database fails with the following message. [crayon-5efe3249f23bf724894730/] Consider the following scenario. Transactional Replication is set on the database from a script and sp_addarticle was used to Publish some of the replication systems tables (in this case, MSpeer_lsns table). When you try to restore the
Read More »