SQL 2000 DTS problem "copying file"error - TechRepublic
General discussion
March 17, 2002 at 12:41 AM
dlanors

SQL 2000 DTS problem “copying file”error

by dlanors . Updated 24 years, 3 months ago

In running the DTS to copy a database from a SQL 7 server(running under NT 4.0) to a SQL 2000 server (running Win2K), using a domain login account (admin account, which is also the startup account for SQL on both servers)I get a success on the logins, the creating of the share point, the detach of the database, the putting database into single user mode, but then a failure (after approx. 90 seconds) on the file copy step. It then successfully reattaches and delets the share point. The error code is listed as a permissions problem, but being the admin on both machines, as well as having the admin in the sysadmins role on both SQL servers, I am at a loss to figure out what is happening here….

This discussion is locked

All Comments