Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Truncating the Transaction Log
Message
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
00518393
Message ID:
00518778
Views:
4
Thank You, John.
What is IIRC and BOL?

>Once a [need] is cleared (which will probably happen as the database is used), then SQL Server can clear out the junk pages inbetween. Also, IIRC, BOL has some stuff regarding this behavior if you need to find out more.
>
>HTH,
>John Barone
>
>
>>Hello,
>>
>>I have log file more that 4GB while data file is 4.5GB.
>>I've tried to truncate log file, but size of the file doesn't chenged.
>>Where is the problem?
Giedrius
Previous
Reply
Map
View

Click here to load this message in the networking platform