batch file to backup and restore microsoft sql server.

backup_restore_ms_sql.bat

@echo off
REM  title           : backup_restore_ms_sql.bat
REM  description     : batch file to backup and restore microsoft sql server.
REM  author          : Agung Pambudi
REM  website         : http://agungpambudi.com
REM  email           : [email protected]
REM  requirement     : MS SQL 2005
REM     	 	                           _         _ _
REM  ___ ___ _ _ ___ ___ ___ ___ _____I I_ _ _ _I I_I  ___ ___ _____
REM I .'I . I I I   I . I . I .'I     I . I I I . I I_I  _I . I     I
REM I__,I_  I___I_I_I_  I  _I__,I_I_I_I___I___I___I_I_I___I___I_I_I_I
REM     I___I       I___I_I
REM 
:init
cls
color 1e
echo *********************************************************
echo.
echo  BACKUP AND RESTORE MS SQL 2005
echo.
echo *********************************************************
:option
echo.
echo.
echo -------------------------------------------------------
echo [1] Backup  
echo [2] Restore           
echo [3] Exit    
echo =======================================================
echo.
set/p "opt=Your Choice: "
if %opt%=='' goto option
if %opt%==1 goto bck
if %opt%==2 goto rst
if %opt%==3 goto ext
goto option
:bck
cls
set/p serverhostname=Input Server Hostname [ex. ITROSBS2\SNS] :
set/p dbname=Input Database Name [ex. BOSnet-SNS-Sentralisasi-8047] :
set/p destinationpath=Input Destination Path [ex. F:\] :
echo.
echo ===============================================
echo.
echo Information
echo.
echo Server Hostname: %serverhostname%
echo Database Name: %dbname%
echo Destination Path: %destinationpath%
echo.
echo ===============================================
echo.
echo Execute:
SQLCMD -E -S %serverhostname% -Q "BACKUP DATABASE [%dbname%] TO DISK='%destinationpath% %dbname%.bak'"
pause
goto option
:rst
cls
set/p serverhostname=Input Server Hostname [ex. ITROSBS2\SNS] :
set/p dbname=Input Database Name [ex. BOSnet-SNS-Sentralisasi-8047] :
set/p sourcepath=Input Source Path [ex. F:\] :
set/p filename=Input Filename [ex. ex. BOSnet-SNS-Sentralisasi-8047.bak] :
echo.
echo ===============================================
echo.
echo Information
echo.
echo Server Hostname: %serverhostname%
echo Database Name: %dbname%
echo Source Path: %sourcepath%
echo Filename : %filename%
echo.
echo ===============================================
echo.
echo Execute:
SQLCMD -E -S %serverhostname% -Q "RESTORE DATABASE [%dbname%] FROM DISK='%sourcepath% %filename%'"
pause
goto option
:ext
exit