March 23, 2006 at 12:42 pm
I have SQL 2000 server with sp3a in our head office and a remote office. I took the database backup of 1st server and restored to the 2nd server. Then I setup a daily job to run DTS 'Copy SQL server objects task' to copy only date of the tables from 1st server to the 2nd server. But when I run the DTS, although part of the data has been transfered, it gives an error:
Step Error Source: Microsoft SQL-DMO
Step Error Description:[SQL-DMO]The Bulk Copy execution failed.
Step Error code: 80045707
Step Error Help File:SQLDMO80.hlp
Step Error Help Context ID:1131
Please help!
Thanks
March 27, 2006 at 8:00 am
This was removed by the editor as SPAM
March 28, 2006 at 8:52 am
If you start the dts-copy as your self do you have sufficient authority on both servers because the job uses your account ? and on the other hand if the copy is started by sql server agent as a job then also the account that the agent is running on must have enough authority on servers.
Have you also checked that on what ever account is used the account has sufficient privileges to all database tables as well as files on both servers.
Insufficient authority should be revealed easily in event viewer logs on either server the problem occurs.
March 28, 2006 at 2:20 pm
I was using 'sa' to create / run DTS. I have checked the event viewer on both server, and there is nothing related to SQL-DTS.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply