The oldest transaction was in that transaction log file (4296), and that was uncommitted.
When you deactivated the database you terminated (rolled back) that transaction.
If this happens again, try to discover which transaction was hanging around for so long uncommitted, and try to resolve that (sometimes, later fixpacks resolve problems like this ).
the "First active log file" value changed only after I deactivated and activated the databases. Also, since my log related configurations on a database are same on Primary and Secondary database I would expect this "First active log file" value to be same on both sides, and that happened only after I did deactivate/activate the db on secondary database.
Last edited by gvphubli; 05-21-12 at 15:15.
Reason: incomplete reply