One of our users left a stored proc running Friday night, the proc was inserting records into a table. The transaction log filled up the drive and is now 2.2 gig. Monday AM the proc was killed and started rolling back. The database is now in recovery mode
and "approximately 1868894 seconds remain" and is unusable.
How can I get the database back to a usable state in the shortest amount of time?
View Complete Post