Tuesday, March 27, 2012

DTS Failure

Whats happens when moving a sql server database to another sql server database and the DTS fails. Does it copy half the data or it doesn't copy any data??

No it does not that is why we usually back up the current copy before implementing a new one if roll back may be needed. Hope this helps|||Oh Ok, Thank u so much, that was my interview question.

No comments:

Post a Comment