Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Log file is too big?
Message
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:
01280439
Vues:
29
>>>>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.
>
>>>That worked...the part I was missing changing the recovery model....
>>>Thanks!
>
>Glad it helped.
>
>If you want to take advantage of the log in the future, change the reoovery model back to full and put in a backup procedure that will take care of shrinking the log for you.

...That's excatly what I've done.
Thanks again!
ICQ 10556 (ya), 254117
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform