thanks Steve,

I have to create a replication., I can't create a replication with creating a publishere

backup

restore the db in to the 2nd box

create subscription

That the path I follow and...

step that I took

1. create a publisher on "A" db on box "1"

2. backup the "A" db

3. restore "A" db into subscriber with "B" name on box "2"

4. check the...

still same error, there is no distributor, and local server is not a distributor

Thanks, I will check and run it

db is running. I can't alter the 626 tables or sysobjects to 0

I got 626 row back

still not deleting, no distributor

first I create a publisher then take a backup of the db and restore into the Subscriber and got unwanted publisher on my subscriber box.

Thanks for reply,

1. I can't use Subscriber server as a distributor.

2. there is no agent job is running on Subscriber server because there is no distributor.

Thanks for reply,

I try but getting error "Distributor server is not assign"

I try to delete unwanted publishers that copy into the subscriber when I restore the db into the subscriber...

Sorry,

No processer is running for replication

Thanks,

I am running 2005 and did not have a distributor(distributor db) set up on that box, and I can not use that box as a distributor.

I can't see the eplication...

Thanks, That I am planning to do that

Thanks

how is possible, we have publisher is 2008 and subscriber 2005.

I think it should be subscriber first then publisher, please confirm.

i already test I can replicate the data from...