Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
TruncateLogOnCheckpoint
Message
De
23/03/2001 08:55:42
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Copies de sauvegarde
Titre:
TruncateLogOnCheckpoint
Divers
Thread ID:
00487961
Message ID:
00487961
Vues:
53
Hi - apparently, according to the SQL help below ...

Important Setting the TruncateLogOnCheckpoint property to True implies that backup-maintained database integrity relies on backup of the database only. When True, you cannot backup a database transaction log and backup strategies based on incremental backup of the log are not available.

... having the Truncate Log on Checkpoint option selected in effect, makes transaction log back-ups useless. Is this true, and if so, What advantage or reason would one have to set this option on?

TIA,
Ken B. Matson
GCom2 Solutions
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform