Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TruncateLogOnCheckpoint
Message
From
23/03/2001 08:55:42
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Backups
Title:
TruncateLogOnCheckpoint
Miscellaneous
Thread ID:
00487961
Message ID:
00487961
Views:
54
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
Next
Reply
Map
View

Click here to load this message in the networking platform