1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| foreach ( $db in $dbt2.split()) {
{
$sqlcheckdb = "USE ${dbt2}"
Invoke-Sqlcmd -ServerInstance $serverPort -Query $sqlcheckdb
if($?)
{
$sqlbackup = "BACKUP DATABASE [$($1db1)] TO DISK = N'${backname}'WITH NOFORMAT, INIT, SKIP, NOREWIND, NOUNLOAD, COMPRESSION"
$sqlbackupCopy = "BACKUP DATABASE [$($1dbtoarch)] TO DISK = N'$backnameCopy'WITH NOFORMAT, INIT, SKIP, NOREWIND, NOUNLOAD, COMPRESSION"
Invoke-Sqlcmd -ServerInstance $serverPort -Query $sqlbackup
#Invoke-Sqlcmd -ServerInstance $serverPort -Query $sqlbackupCopy
if($?)
{
Invoke-Sqlcmd -ServerInstance $serverPort -Query $sqldropdb
}
} |
Partager