Dan
>you have two questions here and the answer to the first one is the problem
>you describe in the second one.
>
>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
>database.
>
>
>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
>*realy* big.
>
>if this is too general you may want to do some reading about administering
>SQL Server.
>
>
>
>-----------------------
>Denny Figuerres
>InReach Internet
>MIS Manager
>
>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.
>>
>> Thanks
>> Dan
>>
>>
>> For more information about this list, including removal,
>> please see http://www.iea-software.com/maillist.html
>>
>
>
>For more information about this list, including removal,
>please see http://www.iea-software.com/maillist.html
>