[Mssqlcompressed-users] mssqlcompressed with powershellscript

[Otis L. <oti...@go...>]

Hi all,
now i have integrated the msbp.exe in a litle powershellscript, which
the taskplaner starts every night:
powershell.exe  D:\DB-Dumps\MSSQLCompressedBackup\BackupScriptForDBs.ps1

- so, that i have a backupserie from a whole week, maybe, that
somebody could make use of this litle script.


function BackupFolder
{
    param( [object] $objSrcFolder, [object] $objDstFolder)
    $strSrcFolder = $objSrcFolder.Path
    $strDstFolder = $objDstFolder.Path
    $colSrcFiles = $objSrcFolder.Files
    $colDstFiles = $objDstFolder.Files

    $ActualDay =    (get-date).dayofweek.toString() + "_"

       #after backing up the database - rename the logfile and db-zip
with the actual days
       foreach ($objSrcFile in $colSrcFiles)
        {
              Rename-Item ($strSrcFolder + "\"  +  $objSrcFile.Name)
-NewName ($ActualDay  + $objSrcFile.Name )
        }
       #move it from the db-server to another storagelocation in the intranet
       foreach ($objSrcFile in $colSrcFiles)
        {
            move-item ($strSrcFolder + "\" +  $objSrcFile.Name )
$strDstFolder  -force
        }

    }


# -----------------------------------------------------
# main
#backup the db and rename it with the actual day and move it to another location

$strSourceFolder      = "D:\DB-Dumps\MSSQLCompressedBackup\BackupsTmp"
$strDestinationFolder = "\\Test-sqlb01\NVinity\RepositoryBackups_Test-EntwDB01"
$FSO = New-Object -COM Scripting.FileSystemObject
$objSourceFolder = $FSO.GetFolder($strSourceFolder)
$objDestinationFolder = $FSO.GetFolder($strDestinationFolder)

#backing up the db
invoke-expression -command "D:\DB-Dumps\MSSQLCompressedBackup\msbp.exe
 backup  `"db(database=NV_REP_ENTWICKLUNG)`"
`"zip64(level=3;filename=NV_REP_ENTWICKLUNG.bak)`"
`"local(path=d:\db-Dumps\MSSQLCompressedBackup\BackupsTmp\NV_REP_ENTWICKLUNG.bak.zip)`"
>> d:\db-Dumps\MSSQLCompressedBackup\BackupsTmp\NV_REP_ENTW_BACKUP_LOG.txt
"

#after running the msbp.exe, i backup the logfile and dbbackupfile to
another place in the intranet
BackupFolder $objSourceFolder $objDestinationFolder

best regards!
Otis