Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

online piecemeal restore with mirroring Expand / Collapse
Posted Tuesday, June 11, 2013 4:41 AM


Group: General Forum Members
Last Login: Tuesday, December 30, 2014 8:21 AM
Points: 10, Visits: 124
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,

Kindest Regards,

Mr B

Post #1461988
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse