update a
set backupSizeMB = b.backup_size / 1048576
from DBAUtility.dbo.backupschedule as a
inner join msdb.dbo.backupset as b
	on a.databasename = b.database_name
where a.databasename = @DBName
and b.backup_set_id = (select MAX(backup_set_id)
			from msdb.dbo.backupset as c
			where b.database_name = c.database_name)

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

BEGIN TRY

	-- log the start time of the backup
	update QbaseDBAUtility.dbo.backupschedule
	set backupstartdate = GETDATE()
	where databasename = @DBName
	and backupdate = dateadd(dd, 0, DATEDIFF(dd, 0, getdate()))
			
	IF @BackupTtype = 'F'
	
		BEGIN
			SET @SQL = 'BACKUP DATABASE [' + @DBName + '] TO DISK = N' + CHAR(39) + @BackupFolderPath + @DBName +
			'.complete'' WITH  NAME = N' + char(39) + @DBName + ' Complete Backup' + char(39) + ', BUFFERCOUNT = 1024, CHECKSUM'
			EXEC(@SQL)	
		END
	ELSE IF @BackupTtype = 'D'
		BEGIN		
			SET @SQL = 'BACKUP DATABASE [' + @DBName + '] TO DISK = N' + CHAR(39) + @BackupFolderPath + @DBName +
			'.Differential'' WITH DIFFERENTIAL,  NAME = N' + char(39) + @DBName + ' differential backup' + char(39) + ', BUFFERCOUNT = 1024, CHECKSUM'
			EXEC (@SQL)							
		END
		
	-- log the end time of the backup
	update QbaseDBAUtility.dbo.backupschedule
	set backupenddate = GETDATE(),
		BackupStatus = 'Success'
	where databasename = @DBName
	and backupdate = dateadd(dd, 0, DATEDIFF(dd, 0, getdate()))
	
	-- Let's also get the backup size
	update a
	set backupSizeMB = b.backup_size / 1048576
	from QbaseDBAUtility.dbo.backupschedule as a
	inner join msdb.dbo.backupset as b
		on a.databasename = b.database_name
	where a.databasename = @DBName
	and backupdate = dateadd(dd, 0, DATEDIFF(dd, 0, getdate()))
	and b.backup_set_id = (select MAX(backup_set_id)
							from msdb.dbo.backupset as c
								where b.database_name = c.database_name)
END TRY