Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Truncating the Transaction Log
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Divers
Thread ID:
00518393
Message ID:
00518778
Vues:
5
Thank You, John.
What is IIRC and BOL?

>Once a [need] is cleared (which will probably happen as the database is used), then SQL Server can clear out the junk pages inbetween. Also, IIRC, BOL has some stuff regarding this behavior if you need to find out more.
>
>HTH,
>John Barone
>
>
>>Hello,
>>
>>I have log file more that 4GB while data file is 4.5GB.
>>I've tried to truncate log file, but size of the file doesn't chenged.
>>Where is the problem?
Giedrius
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform