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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Transaction Log grows even with backup
I did a manual transaction log backup through Enterprise Manager and it did truncate the log. Why wouldn't the Database Maintenance backup also do the same. I don't see any settings for truncate in the DB Maintenance like there is in the regular backup. Thanks. Tony- tmurnion
- Post #2
- Forum: Microsoft SQL Server: Setup and Administration
-
Transaction Log grows even with backup
We have several databases on SQL 2k in Full recovery mode. We do a complete backup and one transaction log backup every day for each database through Database Maintenance. I thought the transaction log backup would truncate the log but it is not happening on our server. The transaction logs...- tmurnion
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Setup and Administration
