Thread: Log File Size
View Single Post
  #2 (permalink)  
Old 06-25-09, 09:14
Pat Phelan Pat Phelan is offline
Resident Curmudgeon
 
Join Date: Feb 2004
Location: In front of the computer
Posts: 12,585
Setting log file sizes requires some knowledge of both the database engine and the application that uses it. Does your database need FULL RECOVERY or will SIMPLE RECOVERY be sufficient for its needs? Is autogrowth needed, forbidden, or somewhere in between (based on your question it appears to be needed, but I'm not willing to assume that yet). You haven't told us enough about your appliaction for me to answer these questions. Once you know enough to answer these questions (which should take your exisitng application knowledge plus five or ten minutes reading about database backups to acheive), you probably will know how to configure your log file setting.

-PatP
__________________
In theory, theory and practice are identical. In practice, theory and practice are unrelated.
Reply With Quote