1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
|
SET J=%date:~-10,2%
SET A=%date:~-4%
SET M=%date:~-7,2%
SET H=%time:~0,2%
SET MN=%time:~3,2%
SET S=%time:~-5,2%
IF "%time:~0,1%"==" " SET H=0%HEURE:~1,1%
SET REPERTOIRE=C:\save
SET FICHIER=%REPERTOIRE%\backupRWB-%A%_%M%_%J%_A_%H%_%MN%_%S%.bak
IF NOT exist "%REPERTOIRE%" md "%REPERTOIRE%"
cd C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn
sqlcmd -S SRV-DDC2\ERP_SERVER -Q "BACKUP DATABASE DB TO DISK = N'%FICHIER%' WITH INIT, NAME = N'Sauvegarde automatique de la base de données', STATS = 1" |
Partager