• If you want to restore to the 1st May, you need a backup from the 1st May. Since the DB is in simple, you need a backup from the date that you want to recover from.

    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