Dropping replicated DB - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Dropping replicated DB

Author

Topic

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2006-08-21 : 08:00:39

I have a database installed by a 3rd party software and currently marked (suspect) in EM. I need to drop this database but the system will not let me because it is flagged as being replicated even though there is no replication going on this server.

How do I get rid of this?

Jim
Users <> Logic

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-08-21 : 10:23:30

you may need to solve the suspect issue first, before you can drop the database

does your sql log files and event logs provide any hints as to why this database was marked suspect?

HTH

--------------------
keeping it simple...

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2006-08-21 : 11:04:44

It was marked suspect when the 3rd party software was uninstalled.
The problem is even when it was not suspect it was flagged as being replicated (and there for unable to be dropped or disconnected)when there is no replication on the server at all.
I need to just kill this and purge it from my server somehow.

Jim
Users <> Logic

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-08-21 : 11:17:28

I have had to follow the steps in this article http://support.microsoft.com/default.aspx?scid=kb;en-us;324401 a couple of times to completely remove a jacked up replication configuration before. Give the steps a shot and see what happens.

There was another script that I used in the past that was posted on usenet that seemed to be pretty good at doing this too. I'll see if I can dig that one up for you as well.

-ec

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-08-21 : 11:20:58

Here is the script I was referring to. Looks like it was written by Hilary Cotter.

http://groups.google.com/group/microsoft.public.sqlserver.replication/msg/71db1f922401f617?dmode=source

-ec

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2006-08-21 : 12:06:35

Crap Now I have a big problem.

That Script did something to make the system think the install is a 6.5 version instead of a 2000 version.
So now I cannot run EM.

Jim
Users <> Logic

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-08-21 : 12:24:37

quote:
Originally posted by JimL

Crap Now I have a big problem.

That Script did something to make the system think the install is a 6.5 version instead of a 2000 version.
So now I cannot run EM.

wow. what error are you getting?

-ec

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-08-21 : 12:33:57

I think it has something to do with the dropped SP. In this case, I would try to reinstall SQL Server SP4.

Peter Larsson
Helsingborg, Sweden

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-08-21 : 13:43:50

What we do to drop a database that is replicated is restore on top of that database with any database that you have that does not have replication. You can then drop it. When you do the restore, make sure to select the same name as the one that you want to drop.

Tara Kizer

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2006-08-21 : 14:09:26

It will not let me apply the Service Pack and has me dead in the water.

I am Re installing SQL server now.

Sure Tara now you tell me LOL

Jim
Users <> Logic

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-08-21 : 15:23:32

quote:
Originally posted by JimL

It will not let me apply the Service Pack and has me dead in the water.

I am Re installing SQL server now.

Sure Tara now you tell me LOL

holy crap. I've run that script at least a dozen times to breakdown replication in several test environments and have never had a problem like this.

-ec

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2006-08-21 : 15:57:38

I got this from another designer and it worked.

(of course this is after I FUBAR the system and had to reinstall SQl server.)

In MAster
Update Sysdatabases set status = -32768 where name = '<yourdatabase>'

Jim
Users <> Logic

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2006-08-22 : 02:49:40

How about....sp_resetstatus?

------------------------
I think, therefore I am - Rene Descartes

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-08-22 : 03:43:57

quote:
Originally posted by JimL

Crap Now I have a big problem.

Sorry Jim, but this gave me a big laugh

This is not something you want to hear yourself say on a monday.
Better you than me.

I hope everything is up and running now?

Peter Larsson
Helsingborg, Sweden

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources