Stopping Recovery

[dylanwhite]

Hi

I have SQL Ent 2000 which is currently trying to complete a recovery. The Data FIle is 60GB and the Log file is 65GB and i have a massive 24MB free space left on the drive.

When i open Enterprise Mgr it just hangs. Is there any way i can stop recovery before my Database Crashes. As i assume it will never recover and the T-Log will continue to grow.

Can i do something Via cmd line??

Thanks in advance

D

 

[Mich]

I'm not sure about a way to stop recovery, but you should truncate your trans log with each backup. That might save you some room.

 

[JBaileys]

I suggest running an immediate backup using command line. Do you have an additional server to install a restored copy of the database.

Either you are running a very intensive large data store or you have some critical architecture design problems...

 

[SQLBill]

If all else fails. Stop the SQL Server services. That will stop the recovery. However, this MAY cause data corruption. Only do this as the last resort.

Then move the .ldf (log) file to a different location and rename it.

Then attach the .mdf (data) file by itself (sp_attach_single_file_db). That will recreate an empty .ldf (log) file.

ONCE AGAIN, stopping the recovery in this method MAY cause data corruption. But if all else fails, it may be your only solution.

-SQLBill