z.B. Datenbankkonsitenzcheck MSSQL
rem Datenbankkonsistenzcheck
„<Pfad von SQL-Installation>\SQLCMD.EXE“ -S <Server>\SQLEXPRESS -E -i c:\tools\checkdb.sql -o C:\Backup\DB\CheckdbLog.txt
rem Zeitstempel erzeugen
for /f „tokens=1-4 delims=. “ %%i in („%date%“) do (
set day=%%i
set month=%%j
set year=%%k
)
for /f „tokens=1-4 delims=.:, “ %%i in („%time%“) do (
set hour=%%i
set minute=%%j
set second=%%k
set hundredth=%%l
)
copy C:\Backup\DB\checkdbLog.txt C:\Backup\DB\checkdb-%year%-%month%-%day%-%hour%-%minute%.txt