Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
LDF file growth and maintenance
Message
From
24/03/2006 03:29:06
Jon Neale
Bond International Software
Wootton Bassett, United Kingdom
 
General information
Forum:
Microsoft SQL Server
Category:
Backups
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01106710
Message ID:
01107289
Views:
26
This message has been marked as the solution to the initial question of the thread.
Check out ALTER DATABSE in BOL, something like:
ALTER DATABASE database name SET RECOVERY {FULL | SIMPLE | BULK_LOGGED}

In SQL 2000 you could also change the recovery model through EM by right clicking on the database name select properties, click the options tab and change the recovery model. I havent used 2005 yet so not sure how well that description matches.

If you set your model database's recovery model to simple then any new database you create will automatically be created in the simple recovery model.

Does this help?

>How do I make that change?
>
>>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
Map
View

Click here to load this message in the networking platform