Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Log file is too big?
Message
 
 
À
08/01/2008 16:20:46
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01280295
Message ID:
01321344
Vues:
21
>>>truncate it or shrink it...
>
>Here's a very quick and very dirty way to truncate the log.
>In database properties/option change recovery model to simple.
>From the context menu select All Tasks/Shink Database.
>Definitely not the text book way, but it's gotten me out of a few scrapes when the log file had become huge.

Did you then re-apply the FULL recovery model?

Would it help to define file groups for the LOG File?
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform