Quick one. How to set all your databases to a specified recovery model using powershell. You’ll need SQLPSX to run this.
$srv = Get-SqlServer -sqlserver 'ServerName'
$dbs = $srv.Databases | where {$_.Name -ne "DBNotFullRecovery" -and (!($_.IsSystemObject))}
foreach($db in $dbs)
{
$db.RecoveryModel = [Microsoft.SqlServer.Management.Smo.RecoveryModel]::Full
$db.Alter()
}
Sql Server Powershell 
Leave a comment