Post reply

Database 'msdb' cannot be opened

  • October 28, 2009 at 3:15 pm

    #1072109

    Eddie Hendrix (10/28/2009)

    The basic question is: should a valid set of .MDF/.LDF files of the MSDB database be able to migrate, and come online, when moved from server to server?

    Should? Yes. Providing both are there, that they were copied from the source while the instance was stopped (copying files from a running instance is near guaranteed to cause issues) and that there's no underlying file system problems.

    Typically, errors like the one you have are either corrupt files or missing files (or bad permissions)

    I can still provide the error log if your curious.

    If you want to know why these didn't, it would be useful.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply