Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

'PRIMARY' File Group is full error

  Asked By: Ramon    Date: Nov 16    Category: Sharepoint    Views: 1616

Have any of you experienced this error?

All signs point to my log files are full or the SQL server is full. What practices do any of you use to avoid this issue? Any parameters or settings that will automatically shrink itself you'd recommend. The following is a link I found but need some insight before I begin.

Thanks in advance




3 Answers Found

Answer #1    Answered By: Demetrius Mcdaniel     Answered On: Nov 16

You can create a maintenance plan on the SQL server  to shrink db automatically  on a schedule.

Make sure backup is run daily as the transaction log  will keep filling up until a back of the log is issued

Answer #2    Answered By: Jake Harvey     Answered On: Nov 16

You have a few options

You can change the recovery model of your databases (I,.e from full  to simple)

If you do this you will loose the ability to do point  in time recovery on that database because to you don’t have any transaction log  backups


Configure your maintence plans to backup & shirnk the transaction logs , this should sort your problem out

You can also use this syntax to truncate sql  logs

DBCC ShrinkFile (Database_name, 2)


Answer #3    Answered By: Ricky Kennedy     Answered On: Nov 16

I went with your 2nd option last night of shrinking the logs and problem is resolved. Attached link  is a great article on how to shrink the logs for any of you interested in learning more to prevent this problem.

Didn't find what you were looking for? Find more on 'PRIMARY' File Group is full error Or get search suggestion and latest updates.