generating replication scripts for sql server 2005

I am trying to find a full-proof way to generate scripts  that accounts for all publications and the corresponding subscriptions ... I need to be able to re-create all of the trans and snapshot replications on my production environmet ...  

Thank you in advance
DBA2000Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Anthony PerkinsConnect With a Mentor Commented:
You cannot use the Scripts generated from SSMS's Object Explorer?
0
 
sarabhaiCommented:
Backup only scripts that may do your job.
0
 
DBA2000Author Commented:
What does that mean? Are you talking about backing up msdb?
0
 
DBA2000Author Commented:
I did use the scripts generated by SSMS and they work.
Tx!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.