DTS to move database from one SQL server to another.

Hi,
Using SQL7 on both machines:
I used DTS to move a database from one server to another over the network.
The target server had a database established with the same names and table
structures as the source database. I just used the EM tools to commit the
DTS process and it seemed to work fine with no error. But I soon discovered
that there was some minor corruption on the target database.
So my questions are:
1. Is DTS a viable option for copying a database from one physical server to
another?
2. Should I (or do I) have to place the source server in single user mode or
some other state to prevent data corruption?
3. Is there a way to use DTS over the Internet to target the target machine?
I have not found a way to enter a destination IP in EM?
4. Do you guys/gals have any suggestions as to how to best do this?
Thanks,
Stefan
http://support.microsoft.com/default...b;en-us;314546
"Stef" <ss@.ss.com> wrote in message
news:9XRKd.11925$Yg6.1877490@.news20.bellglobal.com ...
> Hi,
> Using SQL7 on both machines:
> I used DTS to move a database from one server to another over the network.
> The target server had a database established with the same names and table
> structures as the source database. I just used the EM tools to commit the
> DTS process and it seemed to work fine with no error. But I soon
discovered
> that there was some minor corruption on the target database.
> So my questions are:
> 1. Is DTS a viable option for copying a database from one physical server
to
> another?
> 2. Should I (or do I) have to place the source server in single user mode
or
> some other state to prevent data corruption?
> 3. Is there a way to use DTS over the Internet to target the target
machine?
> I have not found a way to enter a destination IP in EM?
> 4. Do you guys/gals have any suggestions as to how to best do this?
>
> Thanks,
> Stefan
>
>