Wednesday, March 29, 2017

Step by Step - Always On feature in SQL Server 2012

http://www.sqlhammer.com/how-to-configure-sql-server-2012-alwayson-part-1-of-7/

https://www.mssqltips.com/sqlservertip/2519/sql-server-alwayson-availability-groups--part-1-configuration/

http://www.sqlservercentral.com/blogs/forrards-group-database-blog/2015/08/06/step-by-step-guide-to-setting-up-ms-sql-server-alwayson/

Friday, March 24, 2017

Restore IIS website on WFE

If you accidentally deleted the IIS site in any front-end server or you want to repair WFE IIS. Please use the below steps

When you have multiserver environment, your web application provisioning can go wrong due to many reasons (app pool timeout etc.) and as a result you can get one WFE works while the other does not.

In my case, Deleted IIS folder in my on of WFE and want to restore and I don't want to recreate my web application from scratch. SharePoint provides Provision() and ProvisionGlobally() method.

We ran Provision() on the Deleted WFE and it fixed all our IIS sites (default and internet zone) in one go.

To do this just open power shell on the WFE:

?
$webApp = Get-SPWebApplication https://sharepointsiteURL.com/ 
$webApp.Provision()

$webApp = Get-SPWebApplication https://sharepointsiteURL.com/ 
$webApp.ProvisionGlobally()
If you want you can remove the IIS site completely in WFE IIS manager and Provision() will recreate the IIS site After executing the above commands in powershell