Cannot drop the database XXX because it is being used for replication.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Replication » Cannot drop the database XXX because it is...

22 posts, Page 3 of 3

«««1 2 3

Cannot drop the database XXX because it is being used for replication.

Rate Topic

Display Mode

Topic Options

Author

Message

Rodrigo Moraes-286573

Posted Tuesday, March 29, 2011 3:09 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 03, 2011 7:29 AM
Points: 6, Visits: 19

Hello all

I just find another simplest way to workaround it.

Expand the server in SSMS;
Right-click in Replication folder;
Click "Disable Publishing and Distribution"...

This action should delete all files, jobs and distribution database.

It worked for me.

Hope this helps
Regards

Post #1085880

arbcoll

Posted Saturday, January 12, 2013 10:49 AM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, April 27, 2013 3:02 PM
Points: 8, Visits: 82

Worked like a charm with "Offline" mode!

I had a interesting situation: my database was in Warm Standby mode, and I had a .tuf file deleted. The releiving thing was that I didn't needed this database anymore, but I couldn't delete it because of remained publications from primary log shipped database. The publication couldn't be deleted, of course, because the DB was read only. The DB could not be recovered because of missing tuf file.
The only solution that worked was putting the DB to offline mode, and then deleting manually the data and log files. Also the publication disappeared.

Thanks!

Post #1406392

« Prev Topic | Next Topic »

22 posts, Page 3 of 3

«««1 2 3

Permissions