my 140gb database stack in recovery mode after I restarted sql server service. Log file were truncated few hours just the day before and when I checked now log files are 44gb.
any idea of what I can do to get it on line?
I have a feeling it can take more than one day to rollback all transaction and this is my production database.
backup didn't finish as I only have previous day backup and restore may take more time as log file on a backup maybe as big as current.
is there a way to truncate the log. sql service was restarted off hours.