9 lines
314 B
Batchfile
9 lines
314 B
Batchfile
@echo off
|
|
rem LosaDev 2019: backup.bat [folder] [server] (defaults: D:\LosaBackup, .\SQLEXPRESS)
|
|
setlocal
|
|
set DIR=%~1
|
|
if "%DIR%"=="" set DIR=D:\LosaBackup
|
|
set SRV=%~2
|
|
if "%SRV%"=="" set SRV=.\SQLEXPRESS
|
|
if not exist "%DIR%" mkdir "%DIR%"
|
|
sqlcmd -S "%SRV%" -E -b -v BACKUP_DIR="%DIR%" -i "%~dp0backup.sql" |