Logo 
Search:

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: 1648

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

http://www.banmanpro.com/support/filegroupfull.asp

Share: 

 

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

or

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)

BACKUP LOG Database_name WITH TRUNCATE_ONLY

 
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.
http://www.banmanpro.com/support/filegroupfull.asp

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




Tagged: