December 7, 2008 at 9:45 pm
Can you failover a database while a transaction is open on the database and if so what will happen.
May 13, 2009 at 1:57 pm
During a failover, transactions will try to commit. If they can not commit they will be rollback and fail. If you manually try to failover, I believe, SQL will wait for the open transactions to complete prior to failover.
Raymond Laubert
Exceptional DBA of 2009 Finalist
MCT, MCDBA, MCITP:SQL 2005 Admin,
MCSE, OCP:10g
May 20, 2009 at 11:03 am
Yes u can force a failover to ur mirror server while your transaction is open. When u try to do that, SQL server will ask u that do u want to close all the current transaction that are open or are being executed against ur current database(Principal), if u say yes then SQL will kill all current transaction on ur pricipal database and failvoew to ur mirror server will occur.
May 20, 2009 at 11:15 am
If this happens without your control, the transactions that are not committed are rolled back.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply