March 11, 2013 at 4:28 am
I have been asked to get an answer to this question, although I personally don't think it is possible:
In an AlwaysOn Avail-Groups configuration, following a failure of the primary replica and failover to an *async* secondary replica:
is it possible to restore log backups on the async replica dbs there to get them caught up with prod?
or is data loss inevitable?
Thanks for any input!
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
March 14, 2013 at 12:33 pm
Anyone?
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
March 14, 2013 at 12:43 pm
If by "fail over" you mean start using, then no, you can't. A failover on an asynch setup will cause recovery to happen. Once a database recovers, it is no longer possible to restore tran log backups as the logs will no longer match between the two systems.
March 14, 2013 at 2:19 pm
jeff.mason (3/14/2013)
If by "fail over" you mean start using, then no, you can't. A failover on an asynch setup will cause recovery to happen. Once a database recovers, it is no longer possible to restore tran log backups as the logs will no longer match between the two systems.
Thank you, I actually just did a test on our POC environment.
After stopping the SQL service on the primary replica, the databases on the secondary replicas all go to Resolving state and become unavailable.
It is to that state that I was thinking it might be possible to restore log backups, but I don't think that is possible.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply