Post reply

Query error

  • October 24, 2005 at 6:43 am

    #67005

    Server:Msg 1105,Level 17,State 2,Line9

    Coule not allocate space to the object 'Tutorial' on 'Mytest1db'

    in database because the 'PRIMARY' file group is full.

    When I run a query(which is in DTS) to insert records into a table....i'm getting this error.Please Help....

     

     

  • October 24, 2005 at 7:15 am

    #599465

    Is the disk full?

    Is there enough space for the database to extend to cope with the volume of data your inserting?

    Far away is close at hand in the images of elsewhere.
    Anon.

  • October 24, 2005 at 9:35 am

    #599556

    David-

    Thank You,

    I have all the files in PRIMARY FILEGROUP

    How can I create another Filegroup ?(Would that be a solution for this problem?)

    Please Help....

     

    Thanks Again

    Paris

     

     

     

     

  • October 24, 2005 at 10:11 am

    #599575

    Have you actually determined what is causing the error.

    Is it disk space, the version of SQL Server or is the database in question not allowed to extend?

    If it is disk space then you need to allocate more space by either extending the PRIMARY FILEGROUP (depending on your server spec) or creating additional FILEGROUP.

    BOL (Books Online) has a lot of information about FILEGROUPs and has details of how to create FILEGROUPs and what to do when you create them.

    This is not an area I normally work in and so my knowledge is limited.

    Maybe some one else will jump in with help, either way you need to find the root cause first.

    Far away is close at hand in the images of elsewhere.
    Anon.

Viewing 4 posts - 1 through 4 (of 4 total)

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