Home Forums SQL Server 2005 Administering Full Backup - Restore point in time. RE: Full Backup - Restore point in time.

  • January 13, 2013 at 9:29 am

    #1576683

    durai nagarajan (1/13/2013)

    Hello All,

    Is it posible to restore to any time in point in restore. i am getting issues if i have to restore to date before to the time before itst previous FULL backup time.

    is this the intended behaviour. if it is, is there a work around?.

    Settings in production.

    Full backup daily

    Log backup evey one hour

    Storage team will keep 1 or 2 days backup and delete the rest of the backup and log files.

    I'm slightly confused by your question. Are you asking if it is possible to restore to a point in time to a date/time prior to the earliest full backup you have available?