DTS Failure

I have an existing SQL Server database that we want to move to a bigger
dedicated server. When I DTS from the old to the new, after about 45
minutes I get the error that Bulk transfer failed. There is not further
explanation.
It appears that the tables and data was moved, but none of the non clustered
indexes, stored procedures or jobs were copied. I have tried the transfer
twice withe the same results.
What can I do to get this to work?
TIA,
MikeI would recommend that you give up on DTS and either backup the database, copy the backup to the other server and restore using the with move option or if you can take the database off-line either use sp_detach_db or stop the SQL Server and copy the .mdf and .ldf files to the other server and use sp_attach_db.
"Michael Beck" wrote:
> I have an existing SQL Server database that we want to move to a bigger
> dedicated server. When I DTS from the old to the new, after about 45
> minutes I get the error that Bulk transfer failed. There is not further
> explanation.
> It appears that the tables and data was moved, but none of the non clustered
> indexes, stored procedures or jobs were copied. I have tried the transfer
> twice withe the same results.
> What can I do to get this to work?
> TIA,
> Mike
>
>|||Thanks for the suggestion. The detach and attach works great.
Mike
"Norman" <Norman@.discussions.microsoft.com> wrote in message
news:7A9FDCDB-715A-4123-90AF-7B3C182DFFA1@.microsoft.com...
> I would recommend that you give up on DTS and either backup the database,
copy the backup to the other server and restore using the with move option
or if you can take the database off-line either use sp_detach_db or stop the
SQL Server and copy the .mdf and .ldf files to the other server and use
sp_attach_db.
> "Michael Beck" wrote:
> > I have an existing SQL Server database that we want to move to a bigger
> > dedicated server. When I DTS from the old to the new, after about 45
> > minutes I get the error that Bulk transfer failed. There is not further
> > explanation.
> >
> > It appears that the tables and data was moved, but none of the non
clustered
> > indexes, stored procedures or jobs were copied. I have tried the
transfer
> > twice withe the same results.
> >
> > What can I do to get this to work?
> >
> > TIA,
> > Mike
> >
> >
> >

DTC and firewalls

We have a requirement to utilize MS-DTC from internet facing to an internal
system running SQL Server 2000. Can the DTC be stand alone on a dedicated
server in the external environment and then contact the SQL database through
a specific port? Is this technically possible? Any security implications?Alexis wrote:
> We have a requirement to utilize MS-DTC from internet facing to an internal
> system running SQL Server 2000. Can the DTC be stand alone on a dedicated
> server in the external environment and then contact the SQL database through
> a specific port?
Yes.
> Is this technically possible?
Yes.
> Any security implications?
DTS is a usual SQL Server Client application. All the security
implications are based on this fact.|||Yura, perhaps you misread DTC as DTS. DTC, AFAIK, speaks only RPC which probably makes it tricky
with firewalls (I'm not network expert...). I'm fairly certain that I've read a KB about this,
should be relatively easy to find.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Yura Shalak" <yuras@.nospam.nospam> wrote in message news:up%23UoeohHHA.1456@.TK2MSFTNGP04.phx.gbl...
> Alexis wrote:
>> We have a requirement to utilize MS-DTC from internet facing to an internal system running SQL
>> Server 2000. Can the DTC be stand alone on a dedicated server in the external environment and
>> then contact the SQL database through a specific port?
> Yes.
>> Is this technically possible?
> Yes.
>> Any security implications?
> DTS is a usual SQL Server Client application. All the security implications are based on this
> fact.