I have a SQL DB instance that was stopped/shut down improperly and the msdb system db along with the regular DBs have been "in recovery" for over 2 weeks now. sometimes after a reboot one DB in the instance will work for a while, while all the others still say "In Recovery", but after another reboot, it seems like different DBs are "in recovery" at that point, some that worked previously.
Can i take the MDF and LDF files and restore to a different SQL Instance and restore any of the data? I can't stop or take offline any of the databases while msdb is "in recovery" and can't figure out a way to fix the DB instance. At this point i'm looking at ways around or ways to fix it in a new instance.
thoughts?