Thanks! Everyone this is the best SQL server community I have come to know

Thanks for the link I ran

alter database database_name

set auto_close off

....and rest as they is history...

HEY,

I THINK YOU SHOULD ALLOW YOUR DATABASE .mdf TO GROW AT WILL AND RUN DBCC FOR MAINTENANCE BASIS MAY ON ...

HEY,

HERE A PROC THAT i USED FOR COMPRESSING NIGHTLY DATABASE FILE(S) .BAK HOPE IT...