WhiteLotus (5/1/2015)

---

Grant Fritchey (5/1/2015)

---

ZZartin (5/1/2015)

---

WhiteLotus (5/1/2015)

---

Grant Fritchey (5/1/2015)

---

WhiteLotus (5/1/2015)

---

Grant Fritchey (5/1/2015)

---

3gb is teeny tiny as databases go. Since you're at 99% usage on the data, I'd suggest moving this to a larger drive so you can have it be a whopping 4gb in size.

Just to repeat what the others have said, you're fragmenting the files by constantly shrinking the database. There's no easy way to recover from that either. Please stop.

Honestly my drive doesnt run out of space .. there are still many free space there. But the problem is i hv a monitoring tool that keep giving me the alert saying data file usage is almost 100% .

So i tried so hard to solve this problem .

If i move this data file in other bigger drive .i dont think it will solve problem because data file will be still the same size ( just different location ) .. Am i right ???

'

To be honest i wonder why that data file can't grow anymore . The previous setting for autogrow is by 10% to unlimited . I know it is not good if i let it grow by % So i change it by fixed amount which is 256 MB . But my question is Why they Dont Grow ??

Yes. You are. But, you can expand the size of the file. Add one more gb and your alert should go away. You can't shrink the internal data. You can remove it. But other than that, there's little you can do. You're approaching your alert from the monitoring software incorrectly. Either set an exception for this database, or grow the file so that you have available space.

Seems greatt .. can i do the same thing to system database such as master, model, tempdb ..they all hv the same problems..

Yes you need to let all those databases grow as much as they need to, they shouldn't take much space and bad things happen if they run out of space, unless you're putting user tables in them for some reason.....

Agreed, but set limits so you don't fill the drives.