Filegroup error

  • Can anybody gives solution for the error shown below.

     

    Error at Destination for Row number 1286902.Errors encountered so far in this task :1.

       Could not allocate space for object ‘(SYSTEM table id: -515258363)’ in database ‘TEMPDB’ because the ‘DEFAULT’ filegroup is full.

    I tried to import data into a table from a table in the other database.

     

    Regards,

    Biju.

     

  • Biju

    It looks as if the data impiort process uses temp tables.  You need to expand your tempdb so that it can accommodate all the necessary objects.  Right-click on tempdb in Enterprise Manager, click on the Data Files tab, and increase the value of Space allocated.

    John

  • Thank you very much John

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply