• Hope no one needs to use that database for the next several hours...

    As I said, if you restart, the rollback will continue with the database unavailable. It'll be unavailable until the recovery completes, however long that is.

    Or you can drop the database and restore from backups, assuming you have backups that will allow you to restore up to present.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass