Answered by:
Mirroring possible failures and steps to resolve?

Question
-
Hi All,
We have a strange requirement from one of our client. Exactly saying before configure mirroring as a high availability he wants to know what would be the possible failures can occur in mirroring and how to resolve them. I believe it is hard to have a reported document of it but I'm really grateful if you can share your personal experiences to help me out on this.
To achieve this I need simple scenarios or issue and steps to resolve it. Thank You.
Regards,
Kalyan
----Learners Curiosity Never Ends----
Wednesday, January 22, 2014 2:45 PM
Answers
-
Most common problem is space issue and network problem.
http://technet.microsoft.com/en-us/library/ms190664(v=sql.100).aspx
http://sqlbie.wordpress.com/2013/01/17/troubleshooting-database-mirroring-connectivity-issues/
I would say, you understand the need of setting a database mirroring with your environment underlying infrastructure
http://www.extremeexperts.com/sql/articles/DBMirroring2.aspx
http://msdn.microsoft.com/en-us/library/ms189127(v=sql.100).aspx
-Prashanth
- Proposed as answer by Shanky_621MVP Thursday, January 23, 2014 6:28 AM
- Marked as answer by Sofiya Li Monday, February 3, 2014 1:56 AM
Wednesday, January 22, 2014 4:31 PM -
he wants to know what would be the possible failures can occur in mirroring and how to resolve them.
>>Is that mean during the deployment or after the deployment, if during the deployment means -prashanth provided link gives you the information.
incase of after configuring to know any reason for failure failures-
you cannot say exactly,need to look out the errors in the errologs& eventlogs for the same before analysing-
addition to the above you can aslo refer-
Possible Failures During Database Mirroring
http://technet.microsoft.com/en-us/library/ms190913.aspx
Troubleshooting Database Mirroring Error 1418
http://www.sqlsoldier.com/wp/sqlserver/troubleshooting-atabasemirroringerror1418Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.
- Marked as answer by Sofiya Li Monday, February 3, 2014 1:56 AM
Thursday, January 23, 2014 3:16 PM
All replies
-
Most common problem is space issue and network problem.
http://technet.microsoft.com/en-us/library/ms190664(v=sql.100).aspx
http://sqlbie.wordpress.com/2013/01/17/troubleshooting-database-mirroring-connectivity-issues/
I would say, you understand the need of setting a database mirroring with your environment underlying infrastructure
http://www.extremeexperts.com/sql/articles/DBMirroring2.aspx
http://msdn.microsoft.com/en-us/library/ms189127(v=sql.100).aspx
-Prashanth
- Proposed as answer by Shanky_621MVP Thursday, January 23, 2014 6:28 AM
- Marked as answer by Sofiya Li Monday, February 3, 2014 1:56 AM
Wednesday, January 22, 2014 4:31 PM -
Simple someone shuts down the service...power failure....
Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/
MS SQL optimization: MS SQL Development and Optimization
MS SQL Consulting: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
SQL Server Integration Services: Business Intelligence
Thursday, January 23, 2014 6:24 AM -
he wants to know what would be the possible failures can occur in mirroring and how to resolve them.
>>Is that mean during the deployment or after the deployment, if during the deployment means -prashanth provided link gives you the information.
incase of after configuring to know any reason for failure failures-
you cannot say exactly,need to look out the errors in the errologs& eventlogs for the same before analysing-
addition to the above you can aslo refer-
Possible Failures During Database Mirroring
http://technet.microsoft.com/en-us/library/ms190913.aspx
Troubleshooting Database Mirroring Error 1418
http://www.sqlsoldier.com/wp/sqlserver/troubleshooting-atabasemirroringerror1418Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.
- Marked as answer by Sofiya Li Monday, February 3, 2014 1:56 AM
Thursday, January 23, 2014 3:16 PM