Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
LDF file growth and maintenance
Message
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Copies de sauvegarde
Titre:
LDF file growth and maintenance
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01106710
Message ID:
01106710
Vues:
62
Each night we will be doing a NET STOP, backing up our MDF, LDF, master and model databases, then doing a NET START. My ISP said that since we aren't using the SQL Server backup, that the LDF file will grow over time and affect preformance. He recommends reducing this file in size once per week. He used the word "truncate". A couple of questions.

1) Do I need to worry about the LDF's growing?
2) Is a truncate the same as the term "shrink" that I see in the Mgt Studio UI?
3) Is there a command that I can issue to accomplish this instead of going into the Mgt Studio UI once per week?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform