I recently installed SQL Server 2005 on a new machine. It all appears fine. I ran a large job and the job caused the following files dbname_SHOP_AREA, db_name_LOG1, db_name_LOG2 and db_name_LOG3 to be approx 40Gb in size. How do I clear these down? Is there a setting I have missed in install? or is this a manual task?
As the next time I run a job it uses up all remaining memory on the machine, so I would like this to free itself after each job completion, is this possible?
Thanks in advance.