mirroring Asynch suspended after i ran full backup

Question

mirroring Asynch suspended after i ran full backup

leon2486

Mr or Mrs. 500

Points: 502
More actions
July 23, 2012 at 8:42 pm

#259693

Hi there,
My name is Leo, i am a junior DBA in my company. Nice to meet you all in this forum. 🙂
i have a problem with SQL Server mirroring in SQL Server 2008 R2 SP1 CU4 version. I full backup my database last night and this morning, the mirroring is suspended.
i have tried to resume mirroring but, i got this error in my secondary server :
Database mirroring will be suspended. Server instance 'A000S-DRPSSDB2' encountered error 9004, state 1, severity 25 when it was acting as a mirroring partner for database 'PSS4WMASTER'. The database mirroring partners might try to recover automatically from the error and resume the mirroring session. For more information, view the error log for additional error messages.
is it any related with full backup that i did last night ? or any possibility root cause for my problem ?
Thank you very much for your help...
warm regards,
Leo

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

leon2486 (7/23/2012)
Hi there,
My name is Leo, i am a junior DBA in my company. Nice to meet you all in this forum. 🙂
i have a problem with SQL Server mirroring in SQL Server 2008 R2 SP1 CU4 version. I full backup my database last night and this morning, the mirroring is suspended.
i have tried to resume mirroring but, i got this error in my secondary server :
Database mirroring will be suspended. Server instance 'A000S-DRPSSDB2' encountered error 9004, state 1, severity 25 when it was acting as a mirroring partner for database 'PSS4WMASTER'. The database mirroring partners might try to recover automatically from the error and resume the mirroring session. For more information, view the error log for additional error messages.
is it any related with full backup that i did last night ? or any possibility root cause for my problem ?
Thank you very much for your help...
warm regards,
Leo

Did you check the error log for additional error messages? If so, what are they?

saidapurs Hall of Fame Points: 3477 More actions · Answer 2

Hi Leo,

Backup is not a problem, please cross check the logs on both servers you will get the result....

Satish

DBA328 Hall of Fame Points: 3952 More actions · Answer 3

Backup of the principal database is allowed,so backup should not be the problem. You need to check windows event log and sql server errorlog and see anymore error is logged.

leon2486 Mr or Mrs. 500 Points: 502 More actions · Answer 4

Lynn Pettis (7/23/2012)
leon2486 (7/23/2012)
Hi there,
My name is Leo, i am a junior DBA in my company. Nice to meet you all in this forum. 🙂
i have a problem with SQL Server mirroring in SQL Server 2008 R2 SP1 CU4 version. I full backup my database last night and this morning, the mirroring is suspended.
i have tried to resume mirroring but, i got this error in my secondary server :
Database mirroring will be suspended. Server instance 'A000S-DRPSSDB2' encountered error 9004, state 1, severity 25 when it was acting as a mirroring partner for database 'PSS4WMASTER'. The database mirroring partners might try to recover automatically from the error and resume the mirroring session. For more information, view the error log for additional error messages.
is it any related with full backup that i did last night ? or any possibility root cause for my problem ?
Thank you very much for your help...
warm regards,
Leo
Did you check the error log for additional error messages? If so, what are they?

Hi Lynn,

nice to meet you .. thank you for your response..

yap, there are so many error log about network, i think this is the root cause of my problem.. 🙂

warm regards,

Leo

leon2486 Mr or Mrs. 500 Points: 502 More actions · Answer 5

saidapurs (7/23/2012)
Hi Leo,
Backup is not a problem, please cross check the logs on both servers you will get the result....
Satish

Hi Satish,

nice to meet you ..

yes. i have checked the error log .. and there are so many network problem.. i'll follow up to my network team..

thank you,

best regards,

Leo

leon2486 Mr or Mrs. 500 Points: 502 More actions · Answer 6

DBA328 (7/24/2012)
Backup of the principal database is allowed,so backup should not be the problem. You need to check windows event log and sql server errorlog and see anymore error is logged.

Hi DBA328,

nice to meet you. i have checked the error log and evnetviewer .. i saw a lot of error about network..

i turned off some copy task for this issue and now, my mirroring runs well ..

thank you

regards,

Leo