Thanks for the info. The reason I have to do this is that currently we we are entering data in two places and I am just trying to make...

Thanks for the help everyone 🙂

I have a database that is 205GB and the log file is 30GB. Does that sound about normal?

No one really knows why. I have done some research and I will probably turn them off. Would you suggest having a job shrink it on the weekends?

Wouldn't it be better to shut off Auto Shrink and then have the backup job copy the transaction log and then remove it? Is Auto Close a bad think...