• KcV (12/2/2013)


    yes, i think (99%) didn't checked this option.

    I'm fairly sure you did.

    RESTORE DATABASE <database name> WITH RECOVERY

    If that brings your database online then you did select the option in the restore dialog to leave the database in the restoring state to allow for further backups to be restored.

    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