Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DTS and "Allow Updates" conflict???

Status
Not open for further replies.

Guest_imported

New member
Joined
Jan 1, 1970
Messages
0
I've been trying to move 5 database files from my development machine to my production machine.
After doing a sp_detach_db and phycially deleting the existing files on my destination server, I kicked off a DTS routine to move the files. It appears to have run fine for about 1 hour and then it died. In my SQL server log file for the production system, it indicated that the "Allow Updates" parameter was changed and I must run "reconfigure". Around this same time, I noticed that my DTS running from my source machine died. What is going on? Is there any connection or do I have a bigger problem? I'm trying to move a 100gb environment and I'm running out of time in my 31 hour window.

Arrick
 

Which commands are you using to move the files with DTS? Wouldn't it be faster to COPY the files if on the same domain or use FTP if on different domains? You might be able to pick up time by copying some of the files in parallel. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top