When doing a scheduled "full" backup, does it automatically remove inactive
entries from the translog, or do I need to schedule a separate backup just
for the translog? I am using Sql 2005. Thanks!You'll need to backup the log also (this makes sense if you think of
log-shipping which requires the logs intact and which might be occurring
behind the scenes).
Alternatively, if the log is of no importance (eg on some of my dev
databases) you might want to consider simple recovery mode.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||Dan E wrote:
> When doing a scheduled "full" backup, does it automatically remove inactive
> entries from the translog, or do I need to schedule a separate backup just
> for the translog? I am using Sql 2005. Thanks!
>
That depends on the recovery model you're using. In Simple mode, the
transaction log is purged with every checkpoint, you don't need to do
anything. In Full or Bulk-Logged mode, you need to backup the
transaction log in order to purge it.
Tracy McKibben
MCDBA
http://www.realsqlguy.com
No comments:
Post a Comment