Post reply

Schedule a point in time database restore

  • October 18, 2013 at 9:50 am

    #278192

    Hi,

    i have a requirement to schedule a database restore to point in time. Anyone have a script for this ?

    I know how to schedule a restore using the latest backup data but point in time restore schedule will only work for once...is there any SP or script to achieve this ?

    Please let me know

    Thanks in advance

  • October 18, 2013 at 9:56 am

    #1659785

    If you have access to the server on which the backups were made then you can query backupset and related tables in msdb in order to generate the RESTORE script.

    John

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

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