Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Log file is too big?
Message
 
 
To
08/01/2008 16:20:46
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01280295
Message ID:
01321344
Views:
20
>>>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.

Did you then re-apply the FULL recovery model?

Would it help to define file groups for the LOG File?
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform