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----

Answer 1

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

Answer 2

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

Answer 3

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-atabasemirroringerror1418

---

Thanks, 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.