Schedule SQL server Database Backup using batch (.bat) file

You need to create two file one is TEST.BAT another is TESTDB.SQL

In TEST.BAT File write the following
echo off
sqlcmd -E -S DbInstanceName -i C:\TESTDB.SQL
exit

In TESTDB.SQL you need to write   

DECLARE

@pathName NVARCHAR(512),

@databaseName NVARCHAR(512)

SET @databaseName = 'Enter Your DataBase Name Here'

SET @pathName = 'E:\TEST\DataTEST\Enter Your DB Back Up Name Here_' +

    Convert(varchar(8), GETDATE(), 112) + '_' +

    Replace((Convert(varchar(8), GETDATE(), 108)),':','-')+ '.bak'

BACKUP DATABASE @databaseName TO  DISK = @pathName WITH NOFORMAT,

    NOINIT,  NAME = N'', SKIP, NOREWIND, NOUNLOAD,  STATS = 10

GO 
 
and then simple click on .bat file it's generate the database backup. For schedule, just create a schedule in windows as you wish.