• I think I am late in party 🙂

    I would never recommend to stop recovery process. No one can stop you doing suicide but thats crime 😎

    Jokes apart, You could stop SQL Server in such cases, rename the transaciton log. This will bring database into suspect mode. Then you can run some command to rebuild the log after brining database in to Emergency mode. SQL 2005 has ALTER DATABASE SET EMERGENCY command.

    Let me know if you want more details - bmlakhani@yahoo.com