It depends on whether it is specified in the backup script and on whether the database is configured to do so. The database recovery strategy determines whether the transaction log is truncated or not.
See “Recovery strategies” in NBU for SQL Server Administrator's Guide http://www.symantec.com/docs/TECH127055
Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows. Handy NBU links
No you have to defined that in the script
Thanks and Regards, Dishant Dhokia
Transaction log backup options
■ Back up transaction log, but do not truncate it
Back up a transaction log without truncating it.
■ Truncate transaction log, but don't back it up
(SQL Server 2000) Transaction log is truncated, but is not backed up.
■ Back up and restore tail log
(SQL Server 2005 or later) Backup and recover the tail log from disk.
good Will backing-up
You missed this section in the manual, Bill:
The following options are available when you have chosen a transaction log backup type:
■ Back up and truncate transaction log Back up the transaction log and remove the inactive part of the transaction log.
looks like my post was truncated
Comments
It depends on whether it is
It depends on whether it is specified in the backup script and on whether the database is configured to do so. The database recovery strategy determines whether the transaction log is truncated or not.
See “Recovery strategies” in NBU for SQL Server Administrator's Guide http://www.symantec.com/docs/TECH127055
Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows.
Handy NBU links
No you have to defined that
No you have to defined that in the script
Thanks and Regards,
Dishant Dhokia
per the Admin Guide
Transaction log backup options
■ Back up transaction log, but do not truncate it
Back up a transaction log without truncating it.
■ Truncate transaction log, but don't back it up
(SQL Server 2000) Transaction log is truncated, but is not backed up.
■ Back up and restore tail log
(SQL Server 2005 or later) Backup and recover the tail log from disk.
good Will backing-up
You missed this section in
You missed this section in the manual, Bill:
The following options are available when you have chosen a transaction log backup type:
■ Back up and truncate transaction log
Back up the transaction log and remove the inactive part of the transaction log.
Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows.
Handy NBU links
oops
looks like my post was truncated
good Will backing-up
Would you like to reply?
Login or Register to post your comment.