jschaddock
Programmer
Hello,
We have recently had a server hardware failure that caused our entire server to crash and lose all data. Luckily it was only a contingency server and so we had a copy of everything on our live server to restore across.
We have managed to put all our scheduled jobs on the contingency server using certain tables from the MSDB database and know I am trying to do the same with our DTS packages.
I have found in books online a way of restoring the repository by deleting certain tables and I can then import over the data from the live server into the contingency one which recreated all the repository packages.
However, I can not find a way of getting all our local packages to transfer over using the MSDB database. I fear I will have to tranfer them all over manually by opening and saving them to the contingency server but if anyone knows another easier way then it would be much appreciated.
Thanks
J
We have recently had a server hardware failure that caused our entire server to crash and lose all data. Luckily it was only a contingency server and so we had a copy of everything on our live server to restore across.
We have managed to put all our scheduled jobs on the contingency server using certain tables from the MSDB database and know I am trying to do the same with our DTS packages.
I have found in books online a way of restoring the repository by deleting certain tables and I can then import over the data from the live server into the contingency one which recreated all the repository packages.
However, I can not find a way of getting all our local packages to transfer over using the MSDB database. I fear I will have to tranfer them all over manually by opening and saving them to the contingency server but if anyone knows another easier way then it would be much appreciated.
Thanks
J