October 7, 2008 at 12:55 pm
All,
My current environment has two SQL 2005 Entreprise Editions servers running in database mirror configuration with high safety and automatic failover. I have quite a bit of maintenance work to perform which will require me to break the mirror (updating the new ERP client, deleting stale records, rebuilding indexes) because of the size of the transactions that will occur, leaving the environment in full recovery mode plus the mirror will slow things down quite a bit. I know that you can restore a snapshot, but was wondering if it's possible to restore the mirror copy such so that goes from readonly to available for active transactions?
Regards,
Ian
October 7, 2008 at 2:27 pm
Whilst mirroring is enabled only the Principal database is accessible.
If you want to access the Mirror database without failing over you need to
'Remove Mirroring' and, on the Mirror server, run- RESTORE DATABASE Mydatabase WITH RECOVERY
You could then set that to Readonly while you work on the Principal server.
Set the Principal to Simple Recovery mode, single user etc.
Then recreate the mirror using a full restore
October 8, 2008 at 1:26 pm
Thanks Mark! Worked like a charm.
October 9, 2008 at 1:45 am
You are welcome.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply