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.
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.