My MVP Profile

Sunday, February 05, 2006

Recovering from Extended MOM DTS Package Failures

When your nightly DTS fails for an extended period of time, recovery can prove problematic with SQL transaction logs filling up do to large data transfer. I put together something to illustrate the syntax for running the job manually, with guidance on how to move the data in smaller chunks to bring your system back to normal.


http://www.it-jedi.net/HOW-TO/DTS/dtsfailures.htm


Comments on "Recovering from Extended MOM DTS Package Failures"

 

post a comment links to this post