[dba-SQLServer] Runaway Log File Questions

Ron Allen chizotz at mchsi.com
Thu Mar 3 19:52:43 CST 2005


Hello Carolina,

Thanks for the response and the good ideas.

I've got the db backing up now, shut it down and doing a straight copy
of the folder the files are in. Tomorrow morning I'm going to start
putting the suggestions I got here into action.

Ron


Thursday, March 3, 2005, 11:51:53 AM, you wrote:

CL> Hi!
CL> Well for starters, SQL Server is a hog and will take whatever you let it.
CL> The logs must be truncated on a regular basis, depending on how much data
CL> you need and if you need to be able to restore to a point in time.
CL> We don't need the logs so whenever we load data we immediately truncate the
CL> logs.  We back up every night and our data is in loader files that we also
CL> keep for disaster recovery.





More information about the dba-SQLServer mailing list