c'est la partie colorer qu'il faut regarder....
deogracia 's List: powershell
-
Jun 15, 10
-
-
-
## load SMO assemblies
## use $null to prevent display of assembly load information$null = [reflection.assembly]::LoadWithPartialName("Microsoft.SqlServer.ConnectionInfo")
$null = [reflection.assembly]::LoadWithPartialName("Microsoft.SqlServer.SmoEnum")
$null = [reflection.assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo")## set SMO variable
$Smo = "Microsoft.SqlServer.Management.Smo."
$server = new-object ($Smo + "Server") "SQL1"## databse to back up
$bkup = new-object ($smo + "Backup")
$bkup.Database = "AdventureWorks"## set backup device and type
$date = get-date$date = $date -replace "/", "-" # replace / symbols in date part
$date = $date -replace ":", "-" # replace : symbols in time part
$date = $date -replace " ", "--Time-" # show time part
$file = "C:BackupsAdventureWorks" + "--" + $date + ".bak"$bkup.Devices.AddDevice($file, [Microsoft.SqlServer.Management.Smo.DeviceType]::File)
$bkup.Action = [Microsoft.SqlServer.Management.Smo.BackupActionType]::Database## invoke backup
$bkup.SqlBackup($server)
-
-
-
-
c'est le script dont je me sers
-
-
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} }
-
-
-
1 - 6 of 6
20 items/page
List Comments
(0)
List Info
6 items | 1 visits