backup current db in sql server

mssql_backup.sql

create PROCEDURE BackupDB
@path nvarchar(300)	= '/var/opt/mssql/data'
AS
BEGIN
	declare @time nvarchar(30)  = format(getdate(),'yyyyMMdd_HHmmss')	
	declare @dbName nvarchar(150) = DB_NAME()

	declare @sql nvarchar(max)
	select @sql = ' BACKUP DATABASE '+@dbName+' TO DISK = '''+@path+'/'+@dbName+'_'+@time+'.bak'' WITH COMPRESSION '

	--print @sql
	EXECUTE sp_executesql @sql
	
	
END
GO