suppress backup message output

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)."
LVL 6
anushahannaAsked:
Who is Participating?
 
Om PrakashCommented:
I think this cannot be done.
Only thing you can supress is the "x rows affected" when you execute the SQL query. This can be done by using SET NOCOUNT ON

0
 
Om PrakashCommented:
0
 
anushahannaAuthor Commented:
Thanks. But SQL backup does not use xp_cmdshell or parameters like BCP?
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
Om PrakashCommented:
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://www.sqlservercentral.com/Forums/Topic421160-357-1.aspx
0
 
anushahannaAuthor Commented:
good point. it Suppresses it in event viewer, not in SSMS though :(

Any other options?
0
 
anushahannaAuthor Commented:
Thanks om_prakash_p.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.