example.sql

if object_id(N'p_create_backup') is null
    exec('create procedure p_create_backup as return (-1)')
GO
alter procedure p_create_backup (@BackupPath nvarchar(266), @Database sysname)
as

declare @fileName nvarchar(266) = @Database + N'.bak'
      , @safeDatabase nvarchar(258) = quotename(@Database)
      , @fileFullPath nvarchar(266) = @BackupPath + @fileName
      
-- validate filepath here; too lazy atm

exec (N'BACKUP DATABASE ' + @safeDatabase + ' TO DISK = ''' + @fileFullPath + N'''')
GO