Home Forums SQL Server 2005 Administering Restore with point in time RE: Restore with point in time

  • June 22, 2010 at 5:24 am

    #1183233

    Saravanan_tvr (6/22/2010)

    Am not serious, My problem is unable to understand our Gila replies..

    What part of my replies are unclear?

    If you want to restore to 1 May, you need a backup that was taken before 1 May. There's no way to go back in time, to restore to a point before a backup was taken.

    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