sqlbackup

@echo off


set _my_datetime=%date%_%time%
set _my_datetime=%_my_datetime: =_%
set _my_datetime=%_my_datetime::=%
set _my_datetime=%_my_datetime:/=_%
set _my_datetime=%_my_datetime:.=_%

::Projcomm_%_my_datetime%

:: doi voi sql express no bakup vao folder o duoi, neu khong se co loi

::export file bak

sqlcmd -S.\SQLExpress -Q "BACKUP DATABASE PC_TVC TO DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Backup\Projcomm_%_my_datetime%.bak'"

:: Nen file
C:\"Program Files"\7-Zip\7z a "C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Backup\Projcomm_%_my_datetime%.zip" "C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Backup\Projcomm_%_my_datetime%.bak"

del "C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Backup\Projcomm_%_my_datetime%.bak"

::Create folder by date
FOR /F "TOKENS=1* DELIMS= " %%A IN ('DATE/T') DO SET CDATE=%%B
FOR /F "TOKENS=1,2 eol=/ DELIMS=/ " %%A IN ('DATE/T') DO SET mm=%%B
FOR /F "TOKENS=1,2 DELIMS=/ eol=/" %%A IN ('echo %CDATE%') DO SET dd=%%B
FOR /F "TOKENS=2,3 DELIMS=/ " %%A IN ('echo %CDATE%') DO SET yyyy=%%B
SET ngaythang=%dd%_%mm%_%yyyy%

if not exist "C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Backup"\%ngaythang% mkdir  "C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Backup"\%ngaythang%

move  "C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Backup"\*.* "C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Backup"\%ngaythang%

::move  D:\app\Administrator\admin\orcl\dpdump\%user%_%_my_datetime%.dmp D:\app\Administrator\admin\orcl\dpdump\%ngaythang%

exit