Quick Question - PRIMARY filegroup is full

  • Hello,

    I know the reason and how to go about fixing this issue.

    My question is:

    what is the behaviour of all the update/insert/delete(?) requests that cannot be processed.....will they be stored in the transaction log or will the database in effect be in read-only mode once space limit is reached??

    thanks in advance

    samuel

  • All actions that result in a "PRIMARY Filegroup FULL" error are being rolled back. These actions need to be executed again by the application/user. Some other actions (like simple SELECTs) can still be excuted if a filegroup is full.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
  • thanks 🙂

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

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