• Full recovery and no log backups?

    Was the log getting manually truncated? (backup log .. truncate only)?

    Is the database still attached to SQL? (I know the mdf is missing). Is it still listed if you query sys.databases?

    p.s. How do you lose an mdf file?

    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