+34 911 599 883

+34 911 895 172

Fichero BAT para backup programado de SQL Server

 

OSQL -SSERVIDORBD\NOMBREINSTANCIA -Usa -PPASSWORD -b -Q "BACKUP DATABASE BDInfolex7 TO DISK='F:\BackupsSQL\Jueves_BD.bak' WITH INIT

xcopy "F:\BackupsSQL\Jueves_BD_NOMBREINSTANCIA .bak" "\\servidor\Base de datos\Backup\" /y

OSQL -SSERVIDORBD\NOMBREINSTANCIA -Usa -PPASSWORD -b -Q “BACKUP DATABASE BDInfolex7 TO DISK=’F:\BackupsSQL\Lunes_BD.bak’ WITH INIT

rar a -dy F:\BackupsSQL\Lunes_BD.rar F:\BackupsSQL\Lunes_BD.bak
xcopy /Y “F:\BackupsSQL\Lunes_BD.rar” “\\10.10.10.248\BackupsSQL\”