Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Versions des environnements
SQL Server:
SQL Server 2000
It is the production database. It is backed up using Symantec Backup Exec. I did a backup directly in SQL Server and that did not decrease the log file size. I see in Management Studio there is a shrink database task. Is that some I should try?
>
>If yours is a Development Databse then by all means change to Simple Recovery, that's the way it should be.
>If it is a Production Database holding live data of an organisation then taking backups regularly should truncate the log file.
>
>Also please see the Webcast on SQL Server it will clear all your doubts:
>"MSDN Webcast A Primer to Proper SQL Server Development 1 of 10.wmv"
>It can be downloaded from Microsoft's Website.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement