SELECT percent_complete ,* FROM sys.dm_exec_sessions s INNER JOIN sys.dm_exec_requests r ON s.session_id = r.session_id
MSSQLTips : Finding a SQL Server process percentage complete with dynamic management views
Update 14/06/2011 - Sweet SQL Lass has a version to show backup/restore progress. It nicely casts the time elapsed and remaining into minutes too. Sweet SQL Lass : How far has my backup/restore got?