Solved

generating replication scripts for sql server 2005

Posted on 2013-05-28
4
286 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
ID: 39203602
Backup only scripts that may do your job.
0
 

Author Comment

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

Accepted Solution

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

Author Comment

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

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

773 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