<div>
Please check the following link <br />
<a href="http://forums.databasejournal.com/showthread.php?t=11196" rel="ugc">http://forums.databasejournal.com/showthread.php?t=11196</a>
</div>


Please check the following link
http://forums.databasejournal.com/showthread.php?t=11196 [http://forums.databasejournal.com/showthread.php?t=11196]

<div>
Thanks. But SQL backup does not use xp_cmdshell or parameters like BCP?
</div>


Thanks. But SQL backup does not use xp_cmdshell or parameters like BCP?

<div>
Try:<br />
<br />
Suppress SQL Server Backup Messages <br />
<br />
Everytime a SQL Server Backup (or restore) is performed SQL Server writes a message both to the SQL Server Errorlog and the Windows Eventlog. &nbsp;In order to reduce the noice in these logs where there is a large number of databases the messages can be suppressed using the SQL Server Trace Flag 3226.<br />
<br />
<a href="http://wardyit.com/blog/blog/archive/2005/10/25/49.aspx" rel="ugc">http://wardyit.com/blog/blog/archive/2005/10/25/49.aspx</a><br />
<a href="http://www.sqlservercentral.com/Forums/Topic421160-357-1.aspx" rel="ugc">http://www.sqlservercentral.com/Forums/Topic421160-357-1.aspx</a>
</div>


Try:

Suppress SQL Server Backup Messages

Everytime a SQL Server Backup (or restore) is performed SQL Server writes a message both to the SQL Server Errorlog and the Windows Eventlog.  In order to reduce the noice in these logs where there is a large number of databases the messages can be suppressed using the SQL Server Trace Flag 3226.

http://wardyit.com/blog/blog/archive/2005/10/25/49.aspx [http://wardyit.com/blog/blog/archive/2005/10/25/49.aspx]
http://www.sqlservercentral.com/Forums/Topic421160-357-1.aspx [http://www.sqlservercentral.com/Forums/Topic421160-357-1.aspx]

<div>
good point. it Suppresses it in event viewer, not in SSMS though :(<br />
<br />
Any other options?
</div>


good point. it Suppresses it in event viewer, not in SSMS though :(

Any other options?

<div>
<div class="content wysiwyg-content">
When a backup is done through code, is there a way to suppress the message, so that it does not get displayed:<br />
&quot;Processed 152 pages for database 'FULLBackup', file 'FULLBackup' on file 1.<br />
Processed 2 pages for database 'FULLBackup', file 'FULLBackup_log' on file 1.<br />
BACKUP DATABASE successfully processed 154 pages in 0.218 seconds (5.754 MB/sec).&quot;
</div>
</div>


When a backup is done through code, is there a way to suppress the message, so that it does not get displayed:
"Processed 152 pages for database 'FULLBackup', file 'FULLBackup' on file 1.
Processed 2 pages for database 'FULLBackup', file 'FULLBackup_log' on file 1.
BACKUP DATABASE successfully processed 154 pages in 0.218 seconds (5.754 MB/sec)."

suppress backup message output

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.