Post reply

consolidate MSDB

  • May 23, 2010 at 8:36 am

    #139098

    Dear Experts, Need your help.

    I have a server running on SQL2005 EE, with 1 user database and with other system db's (master,model,msdb). Now I have restoring in 1 more database with same SQL2005 EE from another system into this server.

    My question is, the existing MSDB have many scheduling jobs/maintenance job. And the New database which I am restoring from another server have its own Scheduling jobs (MSDB). If I restore the MSDB from another server the existing scheduling jobs will be overrided (If not mistaken).

    How to merger this both MSDB / restore all the scheduling jobs from another server.

    please help.

  • May 23, 2010 at 8:55 am

    #1171292

    Read this blog post on how to script out Jobs, you can use these scripts to create the jobs in MSDB for your restored (newly attached) database.

    http://blogs.msdn.com/jenss/archive/2009/01/27/script-out-jobs-in-sql-server.aspx

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • May 23, 2010 at 9:41 am

    #1171294

    You can use SSIS Transfer Jobs Task to copy jobs from one server to another:

    http://www.sql-server-performance.com/articles/dba/ssis_transfer_jobs_task_p1.aspx

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply