Hi,
I need to migrate a database from one server to another using DTS.

The internal document that I'm following states "issues have been
encountered in the past with tables being lost due to lack of space in
TempDB. Check this prior to continuing"

Does anybody have any pointers (as a % of the source DB size presumably) as
to what this actually means in practice?

Your help would be most appreciated.
Many thanks in advance,
Andy

You are moving the whole of a DB from point A to Point B?

Use Backup and restore. Much much easier and cleaner.


Without more details I would not know how you are transferring the tables
and how you come to lose some.


"Andy" <Andy (AT) discussions (DOT) microsoft.com> wrote