How to stop automatic recovery ?

I have a database that is doing a automatic recovery. The
event log indicates this will take about 15 hours. I would
like to stop the recovery and reload from backup. I cannot
connect with Enterprise Manager because it time's out
connecting to the server. Anybody have an idea what I can
do?OK, this is a drastic action.
Stop the SQL Server. Rename the underlying data files (.MDF, .NDF, and .LDF
are the normal file extensions). If you don't have the space to hold the
replacement files, delete them. Restart SQL Server. You can then restore
from backup.
Make sure you want to do this and that your backup is good. This is NOT an
exercise you can undo. If you have the space, I would do a test restore
using a different DB name and file names. Look at the 'WITH MOVE' option
in BOL for RESTORE DATABASE.
--
Geoff N. Hiten
SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Pat" <mcilweep@.ctbsonline.com> wrote in message
news:013a01c35d01$3c70ed10$a301280a@.phx.gbl...
> I have a database that is doing a automatic recovery. The
> event log indicates this will take about 15 hours. I would
> like to stop the recovery and reload from backup. I cannot
> connect with Enterprise Manager because it time's out
> connecting to the server. Anybody have an idea what I can
> do?