July 22, 2002 at 5:53 pm
This is my scenario: I have a secondary server where I have to build as a backup for the production server (primary). The primary server has many jobs and DTS packages. On a daily basis, we backup master, msdb and model databases. What's the best way to setup these jobs and DTS packages in the secondary server? Can this be done by restore of msdb from the primary server, or import of specific tables?
I welcome any suggestions/advice.
July 23, 2002 at 10:00 am
There is an article here that could help. I used the main suggestions and work fine for me.
Article: Copying DTS Packages To a Different Server
By: Andy Warren
Just go to Resources, Articles. Good Luck
July 24, 2002 at 7:44 pm
Thanks for the tip. I read the article and it's very informative. Looks like there is no straightforward way to copy the dts packages. I guess the same holds for sql agent jobs.
For my purpose, I need the two servers to be exact identical. I tested today restoring msdb backup from one PC to another. Initial results are positive - all the jobs and dts packages get copied over. I'll be doing more tests to confirm results.
Thanks again for your help!
July 25, 2002 at 4:54 am
RedGate Software sells a product called Data Compare that you might want to look at it. Compares tables and generates TSQL to make the data the same. Low tech replication. Downside is that it won't do text columns and it doesn't understand "jobs", only sysjobs, sysjobsteps, etc. Restoring MSDB will work - seems like I had problems once with the computer name being different, been a while.
Andy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply