If you are using Windows Server AppFabric in a development or testing environment you will find the need to quickly clear and reinitialize both the persistence and monitoring databases.
Fortunately this is easy with the supplied PowerShell cmdlets. To make it really simple I’ve got a script that I use to reset my environment using the default database names as created by the WebPlatformInstaller with AppFabric.
This is my script AppFabricDBReset.ps1
$ConfirmPreference = "None"
Remove-ASPersistenceSqlDatabase -Force -Server ".\SQLExpress" -Database "AppFabricPersistenceDB"
Initialize-ASPersistenceSqlDatabase -Admins $env:computername\AS_Administrators -Readers $env:computername\AS_Observers -Users "BUILTIN\IIS_IUSRS" -Database "AppFabricPersistenceDB" -Server ".\SQLExpress"
Clear-ASMonitoringSqlDatabase -Database "AppFabricMonitoringDB" -Server ".\SQLExpress"
To run this script I created a batch file called AppFabricDBReset.cmd that does the trick
powershell -file AppFabricDBReset.ps1
Now just run this and watch it clear the AppFabric databases for you