General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2005
Considering you are not using the LDF for backup purposes I would set the backup model to simple this means that none of the transactions will be written to the log and therefore not grow.
Regards
Jon
>Each night we will be doing a NET STOP, backing up our MDF, LDF, master and model databases, then doing a NET START. My ISP said that since we aren't using the SQL Server backup, that the LDF file will grow over time and affect preformance. He recommends reducing this file in size once per week. He used the word "truncate". A couple of questions.
>
>1) Do I need to worry about the LDF's growing?
>2) Is a truncate the same as the term "shrink" that I see in the Mgt Studio UI?
>3) Is there a command that I can issue to accomplish this instead of going into the Mgt Studio UI once per week?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only