About Me

I am a Software Engineer presently working in Microsoft as vendor.The main aim of this blog is to Share my knowledge in Sharepoint,AZURE and Silverlight.

Thursday 19 November 2009

DB Availability with Failover Database server.

Some times Sharepoint site will be down because of database server.

think if it is a production and u left for the day suddenly database server is down the next day you hav to come and fix the issue. :(

fortunately in sharepoint 2010 we can fix this issue with out doing anything. There is a new thing called Failover Database server.

We have to set this property. Sharepoint automatically picks the other database server automatically if the first or primary server is not available.

The other database which we are talking is a mirror of SQL database.

To set this property we have to do as below:

Central Admin-> Application management-> Manage content Databases-> DB->enter the sqlmirror DB value in "FailOver Database Server".

really a cool feature for Admin guys. :)

No comments: