Need Help sa SQL

[rjay92004]

sana may makatulong... hindi kasi ako familiar with SQL... gamit kasi namin sa Access Control System yung SQL for database so yung logs/badge ng mga tao papasok sa database... di namin expect yung badge ng tao is very frequent (labas pasok mga tao sa opisina) kaya yung 8GB database kulang... so nag-upgrade kami to licensed SQL... successful naman ang upgrade kaso after few days may error at sabi sa system/application logs ay "AUTOGROW of the file (Databasename) in database (Databasename) was cancelled by user or timed out after 1466 milliseconds. use ALTER DATABASE to set a smaller FILEGROWTH value for this file or to explicitly set a new file size." ask ko lang po sana kung anong pwede kong gawin dito???

salamat po in advance dun sa willing tumulong at makakatulong...

 

[crypted07]

Try checking yung properties ng database mo kung naka unlimited yung maxsize under memory tab and yung instance na din pa check yung properties check mo kung ano nakalagay ng max size under file tab baka kasi maliit lang ang value. Alam mo naman siguro mag check ng properties. Right click properties lang

 

[esson]

pag ganyan kalaki database mo dapat parati ka nag ttrim

 

[jskhulitz]

trim? ng ano?

 

[crypted07]

buhok?