Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  Wierd Database Backup . . . What happened?

Author  Topic  Jay99 468 Posts Posted - 2001-06-08 : 11:49:43 I have a db . . . close to 1 gig. Did a complete backup . . . succeded . . . Looked at 'Space Allocated' in EntMan and it showed about 700 megs worth of transaction log. (Wierd thing #1, doesn't a full backup truncate the transaction log?) Did a Backup Log on the database I just backed up. . . (this is a test environment . . . no heavy usage). I performed the log backup with in 1 minute of the complete backup . . . produced a .trn of 1.3 GIG!!! (Wierd think #2) performed Backup Log mydb with Truncate_only . . .ok did another backup log and produced a 190K .trn . . . now thats better. So what happened? Why didn't the Complete Backup truncate the log file? Why did 700 megs worth of Transaction log space create a 1.3 Gig backup file? Jay