db_backup_query_RS_DWH.sql

declare @current_date as varchar(10)
declare @backup_filepath as nvarchar(250)
select @current_date = CONVERT(VARCHAR(10), GETDATE(), 105)
select @backup_filepath = N'D:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Backup\dcn-nt-app26_INFA_PC_REPOSITORY_UNICODE_' + @current_date + '_DB'
BACKUP DATABASE [infa_pc_repository_unicode] TO  DISK = @backup_filepath WITH NOFORMAT, NOINIT,  NAME = N'infa_pc_repository_unicode-Ïîëíàÿ Áàçà äàííûõ Ðåçåðâíîå êîïèðîâàíèå', SKIP, NOREWIND, NOUNLOAD,  STATS = 10