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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Why Am I Getting A Large Transaction File Backup?
Lezza Now the 7AM tran file backup is a bit over 6 gigs. It doesn't seem to be failing anymore. After it runs the log file doesn't shrink. I think I read something about transactions remaining open. I will search again, if you have any good references let me know. Thanks...- jbraund
- Post #4
- Forum: Microsoft SQL Server: Programming
-
Why Am I Getting A Large Transaction File Backup?
We recently upgraded our SQL server from 7.0 to 2000. I have a maintenance plan set up that is suppose to perform a transaction log backup from 7:00 AM to 9:00 PM every two hours for a single database. Currently the 7 AM transaction is failing and then the 9 AM transaction is around 5.6 gigs...- jbraund
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
