Guest_imported
New member
- Jan 1, 1970
- 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
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