Skip to main content
Nintex Community Menu Bar
Solved

K2 Database FG_SmartBroker is full, how to fix it?

  • February 5, 2018
  • 6 replies
  • 87 views

Forum|alt.badge.img+16

FG_SMartbroker is showing just 1MB free on the K2 server.

 

We can't save any changes to Smartforms at all.

 

I've ran a K2 Archive and also had Backups done on the DB, but the FG_Smartbroker will not free up space.

 

The K2 DB is showing 2.6GB free, so plenty of free space in the DB, but the Filegroup Smartbroker will not release space.

 

Any ideas?

 

Best answer by Sharpharp1

Got this fixed..........phew

 

It was due to the SQL express hitting that 4GB DB ceiling and not wanting to come back down.

After a frantic week, managed to upgrade it to SQL (proper version) and now filegroups are expanding...

 

 

6 replies

Vernon
Forum|alt.badge.img+14
  • Scout
  • February 5, 2018

Forum|alt.badge.img+16
  • Author
  • Scout
  • February 5, 2018

Hi Vern,

 

Already tried that before posting, the shrink on the filegroup released a tiny 1.44mb (yes that's enough for an old style floppy disk).

 

Still stuck


Forum|alt.badge.img+18
  • February 5, 2018


 


1.  If you Right Click on the K2 database > Properties > Files, is the SmartBroker filegroup currently configured as such?


With AutoGrowth by 10 percent/unlimited?


 


2.  How does the Disk Space on the Drive that would hold this .ndf file look?


Forum|alt.badge.img+16
  • Author
  • Scout
  • February 6, 2018

Hi Tin

 

1) Yes, the Smartbroker is set to Autogrowth by 10%, Unlimited

 

2) Drive holding the ndf has 40GB free

 

 


Forum|alt.badge.img+9
  • February 13, 2018

Are you using SQL Express Edition?


Forum|alt.badge.img+16
  • Author
  • Scout
  • Answer
  • February 13, 2018

Got this fixed..........phew

 

It was due to the SQL express hitting that 4GB DB ceiling and not wanting to come back down.

After a frantic week, managed to upgrade it to SQL (proper version) and now filegroups are expanding...