DECLARE @pathName NVARCHAR(512) SET @pathName = 'C:\Backup\dbbackups\db_backup_' + Convert(varchar