Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How safe is to run TRUNCATE command for the Log?
Message
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01338162
Message ID:
01338173
Views:
25
>>Hi everybody,
>>
>>Our log file is getting too big too often. I'm wondering if there are any implications for doing TRUNCATE command quite often and is it possible to setup it as a job?
>>
>>Thanks in advance.
>
>If you are running regular maintenance jobs (including backup) via SSMS, the log should be getting reset..?

I'm not sure we're running here anything. Can you please tell me what and where exactly should I check?
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform