docs.facundoitest.space

Esto es el script Bckup_DDBB_HDD_USB.bat, que se encargaba de almacenar en una unidad externa varios archivos cada 15 días aproximadamente ~~~ revisado y porteado a powershell en enero de 2021 por Facundo I. ~~~ El mayor inconveniente era que el .bat no asignaba automáticamente la fecha, entonces uno se tenía que acordar todos los meses de modificar eso. Not anymore.

#>

<# algunos parámetros globales… #>

$logfile =“\\192.168.100.34\d$\Log\BackupLog.txt”

$back_date = (Get-Date -Format 'yyyy_MM_dd') $backDate = (Get-Date -Format 'yyyyMMdd') $dirMonth = (Get-Date -Format 'yyyy-MM')

echo “================================================================== ” » $logfile echo “$back_date Backing up SERVER 204 - BBDD Access (mdb) ” » $logfile echo “================================================================== ” » $logfile

$dst =“\\192.168.100.34\d$\$dirMonth\01-BBDD_Manual\BBDD_MSAccess”

$src =“\\192.168.100.204\c$\Aplicaciones\Sistema\Archiv”

cd $dst

mkdir $backDate

xcopy /s /d /y $src\Analis.mdb $backDate » $logfile

xcopy /s /d /y $src\Contable.mdb $backDate » $logfile

xcopy /s /d /y $src\CtaCte.mdb $backDate » $logfile

xcopy /s /d /y $src\Sueldo.mdb $backDate » $logfile

echo “================================================================== ” » $logfile echo “$back_date Backing up SERVER 204 - BBDD SQL Server (bak) ” » $logfile echo “================================================================== ” » $logfile

$dst =“\\192.168.100.34\d$\$dirmonth\01-BBDD_Manual\SQLSrv-Server204”

$src =“\\192.168.100.204\c$\Bak\back”

cd $dst

mkdir $backDate

xcopy /s /d /y “$src\bolsa0\Bolsa0FullBck_$backDate*” $backDate » $logfile

xcopy /s /d /y “$src\rg129\RG129FullBck_$backDate*” $backDate » $logfile

xcopy /s /d /y “$src\SlickTicket\SlickTicketFullBck_$backDate*” $backDate » $logfile

echo ================================================================== » $logfile echo “$back_date Backing up SERVER07 - BBDD SQL Server (folder + bak)” » $logfile echo ================================================================== » $logfile

$dst =“\\192.168.100.34\d$\$dirMonth\01-BBDD_Manual\SQLSrv-Server07”

$src =“\\192.168.100.34\c$\Program Files\Microsoft SQL Server\MSSQL10.DESARROLLO\MSSQL\Backup”

cd $dst

mkdir $backDate

xcopy /s /d /y “$src\CtaCteSql*” $backDate » $logfile

echo ================================================================== » $logfile echo “$back_date Backing up BCCSRV15 - BBDD FireBird 4 (gdb)” » $logfile echo ================================================================== » $logfile

$dst =“\\192.168.100.34\d$\$dirMonth\01-BBDD_Manual\FireBird-Flexxus”

$src =“\\192.168.100.15\f$\Flexxus\DB”

cd $dst

mkdir $backDate

xcopy /s /d /y “$src\DB-Bolsa.gdb” $backDate » $logfile

xcopy /s /d /y “$src\DB-EST-Bolsa.gdb” $backDate » $logfile

xcopy /s /d /y “$src\DB-EST-Prueba.gdb” $backDate » $logfile

xcopy /s /d /y “$src\DB-EST-Prueba.gdb” $backDate » $logfile

echo ================================================================== » $logfile echo “$back_date Backing up BCCSRV08 - BBDD SQL Server 8 (bak)” » $logfile echo ================================================================== » $logfile

$dst =“\\192.168.100.34\d$\$dirMonth\01-BBDD_Manual\SQLSrv-BCCSRV08”

$src =“\\192.168.100.33\c$\Program Files\Microsoft SQL Server\MSSQL12.PRODUCCION\MSSQL\Backup”

cd $dst

mkdir $backDate

xcopy /s /d /y “$src\CalidadTrigo\CalidadTrigo_backup_$back_date*” $backDate » $logfile

xcopy /s /d /y “$src\camaracerealcba\camaracerealcba_backup_$back_date*” $backDate » $logfile

xcopy /s /d /y “$src\master\master_backup_$back_date*” $backDate » $logfile

xcopy /s /d /y “$src\model\model_backup_$back_date*” $backDate » $logfile

xcopy /s /d /y “$src\msdb\msdb_backup_$back_date*” $backDate » $logfile

xcopy /s /d /y “$src\PRD_DOCUMENTACION_AFIP\PRD_DOCUMENTACION_AFIP_backup_$back_date*” $backDate » $logfile

xcopy /s /d /y “$src\PRD_DOCUMENTACION_BCCBA\PRD_DOCUMENTACION_BCCBA_backup_$back_date*” $backDate » $logfile

xcopy /s /d /y “$src\PRD_DOCUMENTACION_HIS\PRD_DOCUMENTACION_HIS_backup_$back_date*” $backDate » $logfile

xcopy /s /d /y “$src\STING_PRD\STING_PRD_backup_$back_date*” $backDate » $logfile

<# echo ================================================================== » $logfile echo Backing up BCCGIS01 - BBDD SQL Server 10 (diez) files … » $logfile echo ================================================================== » $logfile

No llega a la DMZ y el servidor ArcGis no está haciendo los backups de la misma forma

$dst =“\\192.168.100.34\d$\$dirMonth\01-BBDD_Manual\SQLSrv-GIS”

$src =“\\gis\z$\SQLBackups”

xcopy /s /d /y “$src\BCCBA\BCCBA_$backDate*” $dst » $logfile

xcopy /s /d /y “$src\BCCBA_CULTIVOS\BCCBA_Cultivos_$backDate*” $dst » $logfile

xcopy /s /d /y “$src\BCCBA_MonitoreoCalidad\BCCBA_MonitoreoCalidad_$backDate*” $dst » $logfile

xcopy /s /d /y “$src\BCCBA_RallyAgricola\BCCBA_RallyAgricola_$backDate*” $dst » $logfile

xcopy /s /d /y “$src\Economia\Economia_$backDate*” $dst » $logfile

xcopy /s /d /y “$src\GisDemo\GisDemo_$backDate*” $dst » $logfile

xcopy /s /d /y “$src\REM\REM_$backDate*” $dst » $logfile

xcopy /s /d /y “$src\master\master_$backDate*” $dst » $logfile

xcopy /s /d /y “$src\msdb\msdb_$backDate*” $dst » $logfile

xcopy /s /d /y “$src\model\model_$backDate*” $dst » $logfile

#>

<# echo ================================================================== » $logfile echo “$back_date Backing up BCCSRV14 - BBDD SQL Server (bak)” » $logfile echo ================================================================== » $logfile

Esto no corre más, simplemente se restaura desde algún backup de producción

$dst =“\\192.168.100.34\d$\$dirMonth\01-BBDD_Manual\SQLSrv-BCCSRV14-UAT”

$src =“\\192.168.100.145\c$\Program Files\Microsoft SQL Server\MSSQL12.BCCBATEST2014\MSSQL\Backup”

xcopy /s /d /y “$src\STING_Test01_backup_$back_date*” $dst » $logfile

xcopy /s /d /y “$src\STING_Test02_backup_$back_date*” $dst » $logfile

#>