PowerShell: script permissions

If you try to run a PowerShell script you can get something like Script.ps1 cannot be loaded because the execution of scripts is disabled on this system. Yet after running:

Set-ExecutionPolicy Unrestricted

you still get the same message! Then I bet you are running x64 system. That's because there is two versions of PowerShell on the x64 systems, both x64 and x86. And both must be set to desired execution policy to achive desired effect.

SharePoint: Service unavailable

If you receive "Service unavailable" then you try to open SharePoint 2007 Central Administration then it means your application pool for it (usually "SharePoint Central Administration v3") is stopped. But if you start it and it stops again, as you try to open administration page, then it means that you farm credentials are corrupted. This worked for me as a fix:

stsadm -o updatefarmcredentials -userlogin DOMAIN\login -password password

then run:

iisreset /noforce

and have a nice day.

How to force full backup for BizTalk backup job

Sometimes you need to force a full backup of BizTalk backup job. For example, then you reconfigure BizTalk, you can receive an error on some of the BizTalk jobs saying something about that backup is not possible without full backup. To trigger full backup on next job run you need to execute BizTalkMgmtDb.dbo.sp_ForceFullBackup stored procedure. More details can be found here.