tom 28327 (8/28/2013)
I noticed in one of my overnight scheduled log backups that it was huge 500MB for 800MB database. Usually my log backups are relatively small 30MB. I would like to view the contents of the file so that I can see what happened.I can't seem to find a way to do this, can you tell me if there is a way to inspect the backup file to see what transactions occurred?
Thanks,
Tom
Was that about the same time that a Reindexing job or database backup ran, by any chance?
--Jeff Moden
Change is inevitable... Change for the better is not.