Merge Subscription Database move to new Server

FAQ

Profile

Merge Subscription Database move to new Server

Database Forums (Home) -> Replication

Next: Any way to find user who did update in SQL SERVER..

Author

Message

ponnu

External

Since: Mar 09, 2006
Posts: 5

(Msg. 1) Posted: Tue Nov 20, 2007 5:17 am Post subject: Merge Subscription Database move to new Server Archived from groups: microsoft>public>sqlserver>replication (more info?)

I want to move Merge Pull Subscription database to New server(Hardware) without dropping subscription. Note: I do not want copy master and msdb database to new server because collation is different from subscription database. OS : Windows 2003 Server SQL : SQL Server 2000 with SP4 Please let me know your inputs. Best Regards Ponnu >> Stay informed about: Merge Subscription Database move to new Server

Display posts from previous:

Related Topics:

How to move Distribution Database to another disk?? - is possible do this, with out lost the replications already defined ??? or i must to start from zero again??

Can merge replication be used to keep two database in sync - Hello, I have situation as followed. Do you think merge replication would be able to keep both databases in sync? We have two databases (a primary and a secondary) Regular users use the primary database. To keep the secondary data in sync wit...

Merge Replication - 2 way between SQL and Access Database - I want to set up a 2 way merge replication between a SQL Server and Access database. I have set up the publication and subscribed the Access database to it, so any changes I make to the Access database should now translate into the SQL Server database? ...

Remove push subscription from subscriber - Hi everyone. I have an SQL Server 2000 "A" pushing a transactional replica of a database on an SQL Server 2000 "B". Today i removed the subscription from server "A" (publisher), but i still see the subscription on the ser...

Moving Database with Anonymous Merge to NEW Machine - How do you Migrate Merge Agent Subscribers? or do we have to Orphan all obsolete, defunct Replicas? OK; thanks for your help. We got our Database Published, and 30+ Anonymous Subscribers have been happily doing bidirectional Internet updates for over ...

	Database Forums (Home) -> Replication	All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum