Sharepoint Forum

 
Home » Forum » Sharepoint       Ask a questionRSS Feeds

'PRIMARY' File Group is full error

  Asked By: Ramon Morrison         Date: Nov 16, 2003      Category: Sharepoint      Views: 255

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

Tagged:            

 

3 Answers Found

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

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, 2003       

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, 2003       

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.


Your Answer
  • Answer should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].