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:
01338182
Vues:
22
This message has been marked as the solution 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..?
>
>I'm not sure we're running here anything. Can you please tell me what and where exactly should I check?

In SSMS help, look at Maintenance Plans [SQL Server] and Maintenance Plan Wizard under that topic. The wizard is really handy for setting up scheduled maintenance and all the tasks that should be performed.
____________________________________

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