[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 305
  • Last Modified:

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
0
DBA2000
Asked:
DBA2000
  • 2
1 Solution
 
sarabhaiCommented:
Backup only scripts that may do your job.
0
 
DBA2000Author Commented:
What does that mean? Are you talking about backing up msdb?
0
 
Anthony PerkinsCommented:
You cannot use the Scripts generated from SSMS's Object Explorer?
0
 
DBA2000Author Commented:
I did use the scripts generated by SSMS and they work.
Tx!
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now