• thanks a lot! opc.three,

    the very last message on sql log for that database is "The database <db_name> is marked RESTORING and is in a state that does not allow recovery to be run."

    I checked the error log, didn't found any information related the time when the "suspect" happening.

    even more went into physical sql box to verify the event log, had nothing found neither.

    My guess it could be some hardware issues(not failure)

    If the issue would have stroke back, i will post all log info, see if i would missed something on previous verification.

    Thanks again for your reply.