Timeline for How do I set a database back to 'Restoring...'?
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 7, 2014 at 14:07 | comment | added | NibblyPig | Nice. I need to learn more about SQL to figure out how to do all these things. | |
| Jul 7, 2014 at 13:01 | comment | added | James Anderson | depends on the nature of the failure. If the original primary server is still present you can do a log tail restore to bring the secondary up-to-date | |
| Jul 7, 2014 at 12:43 | comment | added | NibblyPig | There's still data loss though between the time you failed over and the time the log was last shipped, the failover server runs in read-only mode because it's much easier than trying to sync back, unless there is a way to eliminate the gap | |
| Jul 7, 2014 at 11:21 | history | answered | James Anderson | CC BY-SA 3.0 |