Solved

generating replication scripts for sql server 2005

Posted on 2013-05-28
4
283 Views
Last Modified: 2013-06-20
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
Comment
Question by:DBA2000
  • 2
4 Comments
 
LVL 9

Expert Comment

by:sarabhai
Comment Utility
Backup only scripts that may do your job.
0
 

Author Comment

by:DBA2000
Comment Utility
What does that mean? Are you talking about backing up msdb?
0
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 500 total points
Comment Utility
You cannot use the Scripts generated from SSMS's Object Explorer?
0
 

Author Comment

by:DBA2000
Comment Utility
I did use the scripts generated by SSMS and they work.
Tx!
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now