We currently run a weekly full backup and daily differential backups using Veritas. The problem we are having is that the transaction log will only truncate following a full backup. We are going through a rapid growth phase where the log grows by as much as 50GB per day. Disk space on our server is becoming a major concern. Any ideas on how to set up a logtruncation after a differential backup?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Backups and the Transaction Log
- Thread starter scotward
- Start date
tlbroadbent
MIS
Perform transaction log backups or change the recovery model of the database to Simple.
FYI: SQL adminstration questions should be posted in forum962 - Microsoft SQL Server: Setup and Administration.
If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:
FYI: SQL adminstration questions should be posted in forum962 - Microsoft SQL Server: Setup and Administration.
If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:
- Thread starter
- #3
tlbroadbent
MIS
You're welcome. The Admin forum is new and it takes time for all of us to adjust to new forums. There's nothing for you to be sorry about.
If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:
If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:
- Status
Similar threads
- Locked
- Question
- Locked
- Question