September 23, 2005 at 4:31 am
Hi,
We are moving our databases from one server to new server. I am trying to do this through DTS using Database Transfers Wizard. Everything looks fine source and destination connections are ok. But when i execute the package it fails with error " Unspecified Error ".
But at the same time when i transfer logins through DTS it succeeds without any error.
Though i have completed my task through backup-restore, still confused about this behaviour of DTS.
Does anybody have any idea about this.....
September 23, 2005 at 5:25 am
hi neeraj,
have u checked there are no users using that databases ?
September 26, 2005 at 5:22 am
gundulz,
We are doing this refresh during database maintenance window and i also made sure that there was no user connected to the database.
Moreover we are moving the database which doesn't exist on destination server so question of user connection doesn't arise.
Please let me know if any other thought comes up
Thanks,
neeraj
September 27, 2005 at 3:20 am
maybe this can help u
http://support.microsoft.com/default.aspx?scid=kb;en-us;274463&sd=tech
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply