Suppress database messages in task

Can you post some screenshots of the messages you are getting? And can you show the part of the code that uses the suppressed message in the template? 

Hi Erwin,

Sure here goes:

These are just one set. The backup file that is being restored can contain up to 120 log backups. A log backup is written to file every minute and this goes on for 2 hours when a new full backup is written to a new backup file. This means there can be a very large amount of messages to be okayed.

The message I’ve created to suppress these SQL Server messages follows a list of restore database / restore log / alter database operations in the task and is called with the following code:

exec tsf_send_message 'suppress', null, 0

This message is defined in the software factory as follows:

This particular message doesn’t show up but it also doesn’t suppress the output of the restore/alter database operations.

Hi Erwin,

In that case you might consider this a feature request. Having tens of database messages in the gui is not practical and suppressing any kind of output would be preferable.

I might work around the issue by creating a SQL Server job and having the task start the job instead. Then the task can keep checking until the job is finished. No SQL Server output will then be generated in the gui.

The database restore takes less than 2 minutes. The 2 hours I mentioned is the interval in which SQL Server writes a log backup to the most recent backup file. Every 2 hours a new backup file is created from a full database backup. A log backup is added to this file every minute. In case the live database needs to be restored there’s a maximum of 120 log backups to be restored. This keeps the restore process relatively fast. And because there’s a log backup after every minute we would lose a maximum of only one minute of live data.