Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Network Performance Monitor (NPM) > Configuration Wizard error: Cannot drop the table ‘dbo.Statusinfo’ because it is being used for replication

Configuration Wizard error: Cannot drop the table ‘dbo.Statusinfo’ because it is being used for replication

Created by Malik Haider, last modified by Malik Haider on Jul 02, 2017

Views: 597 Votes: 2 Revisions: 14

The database configuration fails while trying to restore a replicated database with the following error message:

Cannot drop the table ‘dbo.Statusinfo’ because it is being used for replication.

The same error message appears when running Configuration Wizard in an attempt to resolve the issue.

 

Tried to manually drop same Error " Cannot drop the table 'dbo.Statusinfo' because it is being used for replication  

 

You can also use the SQL Studio on the SQL sever directly and try to drop the table 

 

 

Environment

All NPM versions

Cause

Refer to SQL SERVER – FIX – ERROR : Cannot drop the database because it is being used for replication. (Microsoft SQL Server, Error: 3724) for the cause of this issue.

Is it recommended not to replicate any replication metadata tables. The Create Publication Wizard does not allow system tables to be replicated.  These same checks do not occur when you configure Replication using system stored procedures.

In the source database, if any of the replication system tables are marked for replication (like MSpeer_lsns..) using the stored procedures, restore of this database would fail with the above error message.

Resolution

Refer to Restore of Replicated Database fails with “Cannot drop the table <table name> because it is being used for replication.” to restore the database with KEEP_REPLICATION setting.

 

http://blogs.msdn.com/b/repltalk/arc...plication.aspx

  1. Restore the database with KEEP_REPLICATION setting.
  2. Drop all subscriptions using sp_dropsubscription
  3. Drop all the articles using sp_droparticle
  4. Remove replication using sp_removedbreplication stored procedure

Once Done . Re run the Configuration Wizard. 

Other Related article . 

http://blog.sqlauthority.com/2009/09...er-error-3724/

 

 

Last modified

Tags

Classifications

Public