All I want to do is backup my database....

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Jon Glazer (jglazer.deleteme_at_adconn.com)
Date: 07/08/04 

Date: Thu, 08 Jul 2004 13:33:52 GMT

I have to SQL2000 servers setup and for a while I was backing one to the
other using a DTS package. Now it fails. I cannot figure out why. The
latest error is a "DMO Bulk Copy Execution Failed" error.

Perhaps I am doing this wrong. What should I be doing to totally backup a
database from one server to the other?

Thanks!
Jon