backup_to_network_location
This is an old revision of the document!
Este es el script que adapté para hacer backups en un hdd externo
<# ================================================================================================ 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 #>
backup_to_network_location.1611862723.txt.gz · Last modified: 2024/10/17 21:42 (external edit)