tempdb is the "work space" for SQL server to process queries and such.
you ran out of work space and thus do not have a full copy of your
you may want to check and see if you should make tempdb larger.
you may also want to break up your tranfer into 3 or 4 parts.
are you trying to copy a large calls table? that may be a problem if it is
if this is too general you may want to do some reading about administering
On Sat, 28 Nov 1998, Daniel Wood wrote:
> Why is it that when I copy my working database to another database to
> test Emerald 2.5 as explained in the release.txt that the database size
> is of the new one is about half the size of the old one? Also when I did
> the transfer it came back with a lot of errors saying there was no more
> pages in tempdb.
> For more information about this list, including removal,
> please see http://www.iea-software.com/maillist.html