i have this problem that occourred today with one instance of MSSQL 2008 R2 running on a WIN x64 R2 enterprise server.
i have run a backup maintainance job and now i have two databases in restoring mode for over 4hrs.
my questions are:
why are these databases restoring when i was backing up?
and why are they not being logged anywhere - i can not find anything on logs, activty monitor, or even Windows Resource Monitor.
i can not see any work been done by MSSQL to restore these databases, and yet they are set as 'RESTORING'.
any suggestion from the community here will be much appreciated as i am banging my head against the wall already.
data warehouse | data migration | ETL/ELT | UK | http://www.brainpowered.net
View Complete Post