June 11, 2013 at 4:41 am
Hi all,
We are running with SQL Server 2008 R2 and are in the system design stages of making a large database resilient and recoverable within a set time frame. Our current preferred setup is to use SQL Server mirroring to provide the resilience and ease of server maintenance and combine it with on-line piecemeal restores to enable us to quickly recover in a DR scenario.
Has anyone done it or is it possible to use online piecemeal restore to get the database available and then use this partially restored database to re-create the mirror before allowing database updates to the primary database, then finally finish the restore of the read-only filegroups while the primary and mirror are recording new transactions.
I would really appreciate any help with this or any alternatives that we may be able to consider.
Many Thanks,
Gary.
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply