[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 308
  • 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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