locked
primary file group is full RRS feed

  • Question

  • Primary file group is full for one user db
    This is production server
    Total db size is 132186 MB
    data file is 12000 MB, set automatically grow
    and restrict file growth is 121024 MB

    Now there is 30 GB space on drive

    I have added space to file 3 times(1GB, 10GB, 3 GB) and incresed restrict file growth also(5GB). database is in simple recovery mode.

    stille I am getting above error, pleasee let me know how to proceed now?

     

     

    Tuesday, January 8, 2008 3:52 AM

Answers

  • You can add as much space to the file as you have free on your drive. If you have autogrow set on your datafile, it shouldn't run out of space unless the drive is full.

     

    Can you script out your database and paste it here so we can see which options you have set?

     

    Wednesday, January 9, 2008 9:19 AM

All replies

  •  

    Below are the details for db space used.

    database_name database_size unallocated space
    -------------------------------------------------------------------------------------------------------------------------------- ------------------ ------------------
    databse name 147693.20 MB -20458.09 MB


    reserved , data , index_size , unused
    ------------------ ------------------ ------------------ ------------------
    159694936 KB 93924280 KB 55293752 KB 10476904 KB

    Could you please suggest how much free space can we add to the db primary file group? Or suggest how to proceed further?

    Wednesday, January 9, 2008 2:15 AM
  • You can add as much space to the file as you have free on your drive. If you have autogrow set on your datafile, it shouldn't run out of space unless the drive is full.

     

    Can you script out your database and paste it here so we can see which options you have set?

     

    Wednesday, January 9, 2008 9:19 AM