There is a stored procedure or you can use the DMV in SQL Server 2008. Reading the SQL Server Log Files Using TSQL tells you how to run the stored procedure. If you want to try the DMV, read Tracking Database Recovery Progress Using Information from DMV.