Remain the replication setting after restore database
-
Tuesday, October 09, 2012 2:10 AM
Hi ALL
I will help to migrate database to a new server. and the database currently is pulisher and distributor to replicate data to another server.
how can I remain all the settings of the replication after migration of the database ??
- Moved by Tom Phillips Tuesday, October 09, 2012 2:53 PM Replication question (From:SQL Server Database Engine)
All Replies
-
Tuesday, October 09, 2012 7:56 AMHi anybody has idea ?
-
Tuesday, October 09, 2012 7:59 AMhttp://social.msdn.microsoft.com/Forums/en/sqlreplication/thread/593de2db-02f5-4527-aa76-f8b26a435ec8
Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/
MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
MS SQL Consultants: Improves MS SQL Database Performance
-
Tuesday, October 09, 2012 3:13 PMModerator Best thing to do is to do a backup and restore and then recreate the publication and subscriptions. You can create the script on the existing publisher. Make sure you edit the script to enter the correct logins and passwords as they may be removed in the scripts.
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
- Proposed As Answer by Shulei ChenModerator Friday, October 12, 2012 9:08 AM
- Marked As Answer by Shulei ChenModerator Tuesday, October 16, 2012 9:56 AM
-
Tuesday, October 09, 2012 8:08 PM
As other mention, you should recreate published & setup replciation after backup & restore.
Try in sequence like below :-
1) Drop replcaition
2) Take Backup
3) Restore backup
4) Create publisher & setup replication
Regards,
Rohit Garg
(My Blog)
This posting is provided with no warranties and confers no rights.
Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread.
.png)
