Post reply

Restore to point in time

  • October 19, 2003 at 6:05 pm

    #160069

    Is it possible to go back to a point in time between 2 full backups of a db? I have a full backup at 7 am and another one at 10 am, how can I go back and have the database as it was at 9 am? All I have is these 2 full backups. DB is in full recovery mode, there are no transaction log backup and while taking backup, 'Remove inactive log' option was checked.

    Thanks

  • October 19, 2003 at 6:24 pm

    #478732

    Sorry, forgot to mention that its SQl Server 2000 Enterprise Edition (SP3) on Windows 2000 Server.

    Thanks

  • October 19, 2003 at 10:06 pm

    #478738

    double post

    Edited by - foobari on 10/19/2003 10:07:26 PM

  • October 20, 2003 at 5:50 am

    #478757

    You should be able to back up your tran log and then apply it to a restore (WITH NORECOVERY) of the earlier full backup using WITH STOPAT.

    The "Remove inactive log" option pertains only to tran log backups, it's the same as not using "WITH NO_TRUNCATE" with the BACKUP LOG statement.

    --Jonathan



    --Jonathan

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply