http://michael.carbenay.info

function backup-database($dbName, $rootFolder)
{
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") 
              | out-null
[System.IO.Directory]::CreateDirectory($rootFolder) | out-null
$_srv=New-Object "Microsoft.SqlServer.Management.Smo.Server" "(local)" 
$_bck=new-object "Microsoft.SqlServer.Management.Smo.Backup"
$_bck.Action = 'Database' 
$_fil=new-object "Microsoft.SqlServer.Management.Smo.BackupDeviceItem"
$_fil.DeviceType='File'
$_fil.Name=[System.IO.Path]::Combine($rootFolder, $dbName + "-" 
                        + [DateTime]::Today.ToString("yyyy-MM-dd")+".bak")
$_bck.Devices.Add($_fil)
$_bck.Database=$dbName 
$_bck.SqlBackup($_srv)
write-host "Sauvegarde de " $dbName " terminee"
} 

function backup-alldatabase($rootFolder)
{
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") 
             | out-null
$_srv=New-Object "Microsoft.SqlServer.Management.Smo.Server" "(local)"
$_srv.Databases | 
             ?{$_.IsSystemObject -eq 0} | 
             %{backup-database $_.Name $rootFolder}
}