Recently we've been experiencing a lot of headaches with SQL Server 2008 crashing while restoring a backup taken on a SQL Server 2000 production server. The crash resulted in a stack dump but SQL Server would continue running, although less stable, and sooner or later needed a reboot.
The error was saw was this:
Error: 3414, Severity: 21, State: 1.
An error occurred during recovery, preventing the database 'XYZ' (database ID 10) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support.
In addition, the event log in SQL Server has many info messages about the stack dump. I've been working with SQL Server support on this and as it turns out, there is an issue in the code that reads a 2000 backup and restores it on 2008. It works OK going from 2000 to 2005. The issue has been fixed in the Cummulative update 3 for SQL Server 2008 - http://support.microsoft.com/kb/960484.
If you run into this issue, you can request the hot fix from the above URL.