I have two servers A and B wchich has got transaction replication between them(database name is xx). In that server A is publisher and server B is subscriber.Now i want to copy the database xx from server B Onto server C.When i wanted to this with copy database wizard itz saying that the database has got replication and can not be copied.I wanted to stop this replication and copy this databse xx onto server C.How can do this by stopping replication on server B.
ANY idea is greatly appreciated.
Thanks.Try backup and restore.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment