Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SSIS package to transfer Master and MSDB

Posted on 2006-11-09
3
Medium Priority
?
709 Views
Last Modified: 2012-05-05
I am trying to create a SSIS package to transfer MSDB and Master from my production to my backup. However Master goes fine. MSDB I am having errors with certain Stored Procs.
On google search I found one place where a person said that SSIS has issues with Stored Procs using variables in subqueries. I see that I have some stored procs with that same thing i.e variables in subqueries and they get transferred. Also, the work around of using
a SSIS variable is not easy as when I am transfering 2 dbs.
Any help will be appreciated.
0
Comment
Question by:taposh_dr
3 Comments
 
LVL 5

Accepted Solution

by:
MrNetic earned 1000 total points
ID: 17912520

The best practices for what you wanna do, is to simple backup de Master 6 MSDB, and then do the recovery process from the Dev Server.

But btw, why do you need to replicate this system DB's ?.

Best Regards,

Paulo Condeça.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

972 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