Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How safe is to run TRUNCATE command for the Log?
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01338162
Message ID:
01338172
Vues:
13
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!
____________________________________
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform