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:
01338172
Views:
14
This message has been marked as a message which has helped to the initial question of the thread.
>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..?
____________________________________

Don't Tread on Me

Overthrow the federal government NOW!
____________________________________
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform