Skip to Content
0
Feb 28, 2009 at 07:16 AM

Less than 5% free space in File

303 Views

Hello everybody,

I have been suffer from problem that on Executing DB02, the screen shows the warning that Less than 5% free space in file, when i check the free space on file system then it is 87GB. Auto grow set to 10%, previous is 60Mb, but till i have the problem

statics are

Number of files 5

Total Size MB 71,000

Allocated MB 68,326 = 96.23 %

Free MB 2,674 = 3.77 %

RPDDATA1 14,200 1.00 1,420 E:\RPDDATA1\RPDDATA1.mdf 87,865 10% no limit PRIMARY Less than 5% free space in file

RPDDATA2 14,200 1.00 1,420 E:\RPDDATA2\RPDDATA2.ndf 87,865 10% no limit PRIMARY Less than 5% free space in file

RPDDATA3 14,200 1.00 1,420 E:\RPDDATA3\RPDDATA3.ndf 87,865 10% no limit PRIMARY Less than 5% free space in file

RPDDATA4 14,200 1.00 1,420 E:\RPDDATA4\RPDDATA4.ndf 87,865 10% no limit PRIMARY Less than 5% free space in file

PLease suggest me how to solve this problem bcz. Now free space in only 3.77% .

thanks