Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Log file is too big?
Message
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01280295
Message ID:
01280439
Views:
18
>>>>truncate it or shrink it...
>>
>>Here's a very quick and very dirty way to truncate the log.
>>In database properties/option change recovery model to simple.
>>From the context menu select All Tasks/Shink Database.
>>Definitely not the text book way, but it's gotten me out of a few scrapes when the log file had become huge.
>
>>>That worked...the part I was missing changing the recovery model....
>>>Thanks!
>
>Glad it helped.
>
>If you want to take advantage of the log in the future, change the reoovery model back to full and put in a backup procedure that will take care of shrinking the log for you.

...That's excatly what I've done.
Thanks again!
ICQ 10556 (ya), 254117
Previous
Reply
Map
View

Click here to load this message in the networking platform