DECLARE @sql_sql NVARCHAR(MAX) = N'',
        @backup_param NVARCHAR(MAX) = N'',
        @server_name SYSNAME = REPLACE(@@servername, N'\', N'$'),
        @db_name SYSNAME = DB_NAME(),
        @file_path NVARCHAR(4000);

SET @file_path = N'e:\Shared\Backup' + N'\' + @server_name + '\' + @db_name + '\FULL\FLYWAY_' + @server_name + N'_' + @db_name + '_FULL_' +
REPLACE(CONVERT(NVARCHAR(10), GETDATE(), 102), N'.', N'') + '_' +
REPLACE(CONVERT(NVARCHAR(8), GETDATE(), 108), N':', N'') + '.bak';

IF EXISTS (SELECT 1 FROM sys.configurations c WHERE c.name = N'backup compression default')
  SET @backup_param += N', COMPRESSION';

SET @sql_sql = N'BACKUP DATABASE ' + QUOTENAME(@db_name) +
N' TO DISK = ''' + @file_path + '''';

SET @backup_param = NULLIF(LTRIM(RTRIM((@backup_param))), N'');
IF (@backup_param IS NOT NULL)
BEGIN
  SET @sql_sql = @sql_sql + N' WITH INIT ' + @backup_param;
END;

EXEC sys.sp_executesql @sql_sql;
GO