docs.facundoitest.space

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
Este es el script que adapté para hacer backups en un hdd externo


<code powershell>

<#
================================================================================================
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

#>
</code>