x

Renaming Database while it is in Replication

Dear Mate,

need to rename a database which is in replication. Getting this error:

Can not rename the database because it is published or it is a distribution database used by replication. (Error 188855)

what could be the solution?

more ▼

asked Jan 19, 2012 at 09:38 AM in Default

avatar image

Zahid
91 10 10 11

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

You have to take it out of replication completely, rename, then reestablish replication.

more ▼

answered Jan 19, 2012 at 10:29 AM

avatar image

Grant Fritchey ♦♦
137k 20 43 81

(comments are locked)
10|1200 characters needed characters left

that means, i need to disable to Distribution and Publications. And If i do that I have to set the replication from the beginning!? Is there any other way without removing replicatrion fromt he database?

more ▼

answered Jan 20, 2012 at 02:22 AM

avatar image

Zahid
91 10 10 11

(comments are locked)
10|1200 characters needed characters left

a small correction on the error code. the correct error code was 18855.

more ▼

answered Jan 20, 2012 at 02:25 AM

avatar image

Zahid
91 10 10 11

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x377

asked: Jan 19, 2012 at 09:38 AM

Seen: 1748 times

Last Updated: Jan 19, 2012 at 09:52 AM

Copyright 2017 Redgate Software. Privacy Policy