Success! 😎
To tell you the truth I am blown away that there wasn't more information on this on BOL or MS forums...almost makes me feel special that I AM THE ONLY ONE 😛 who's ever ran into this...
1421813 transactions rolled forward in database 'distribution' (25). This is an informational message only. No user action is required.
0 transactions rolled back in database 'distribution' (25). This is an informational message only. No user action is required.
Recovery is writing a checkpoint in database 'distribution' (25). This is an informational message only. No user action is required.
CHECKDB for database 'distribution' finished without errors on 2012-02-15 21:08:54.840 (local time). This is an informational message only; no user action is required
A strange observation: There errors arose the entire time the distribution DB was recovering:
Error: 18456, Severity: 14, State: 38.
Login failed for user MYCOMPANY\ThatUser'. Reason: Failed to open the explicitly specified database. [CLIENT: <local machine>]
After the Recvoery completed, the errors stopped. I've verified that user has in no way anything that ties it to the distribution database???
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience