Restoring DB's/logs to a different server

  • Hi - I have a bunch of maintenance plans on my production SQL clustered server that do a full backup once, differentials every day of week except for day when full is done, and logs every hour. Differential backups are done everyday that the full backup isn't done via a Job. Every day these files are "snap-mirrored" to our DR site to be able to be used in case we should need to put DR into production. I want to be able to setup different jobs for each DB to do the restores however I am having issues with this because the Full and log backups get timestamps applied to them. Has anyone done anything like this? How do I go about setting up the job to do the restores if the file names aren't static? Also I don't want to apply any of the log backups that are before the Differential backup.

    Any help on this would be greatly appreciated.

    Thanks

    😎

  • How about log shipping?

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

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