A tip if you are experimenting with the new SQL Server 2005 online PAGE restore functionality in SQL Server 2005 (or the online FILE restore), and you get a message like this after applying a RESTORE DATABASE (with NORECOVERY) and any other tran log backups (up to RECOVERY):
"The roll forward start point is now at log sequence
number (LSN) 17000000031000001. Additional roll forward
past LSN 17000000031800001 is required to complete the
restore sequence."
Online restores require that you also take a BACKUP LOG after the RESTORE DATABASE file or page(s) restore. Then you apply that log backup (RESTORE LOG).