We are running backup and replication 8.
We have a scenario where we have to protect a SQL server in a disaster recovery scenario.
Our backup config is to have an incremental backup running a 1 am every morning, with application aware log shipping to ship logs every 1 hour to our backup repository.
We also have a replica backup that runs once the incremental has finished.
What we are looking to do is document and test our disaster recovery for if the original server should ever die on us.
What we cant seem to be able to find is a way to replay the SQL logs into a different server, preferably the replica we have created each night.
Is this possible or is the only way to recover a server like this is to do a full image-based restore and then replay the logs back the server that has been recovered?
Any help or guidance would be greatly appreciated.