SQL Server Performance Forum – Threads Archive
DR planHi Group, We have a separate distributor server. There are around 150 publications. We need a disaster recovery plan for this server. Whats the best way to script out every publication including replciation jobs and permissions and distribuition database. Thanks
You can do the scripts manually through SSMS…
OR you can use SQL dmo OR smo to automate scripting… http://www.replicationanswers.com/Script5.asp
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.
If you are using SQL 2005 then SMO is best option, we are in process to develop such API that can take care of scripting as a first hand utility and as normal we use our DR plan template to test it to be assured. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.