InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 03:03:03 GMT20http://www.sqlservercentral.com/Forums/Topic427092-357-1.aspx[quote][b]shloghomes (2/5/2013)[/b][hr]Apparently this only effects the SQL log files.I want to eliminate the SQLSTATE 01000 messages from the Backup command when calling it from a SQL Agent job. The output history is almost worthless when you are backing up multiple databases across an entire server.Processed 192 pages for database 'Address1', file 'Address1' on file 1. [SQLSTATE 01000]Processed 1 pages for database 'Address1', file 'Address1_log' on file 1. [SQLSTATE 01000]BACKUP DATABASE successfully processed 193 pages in 0.336 seconds (4.487 MB/sec). [SQLSTATE 01000]Repeated for every database on the server...We only want to see error messages...Can anyone help with this?[/quote]My guess, no. Looks like you get this message wether you want it or not.Tue, 05 Feb 2013 10:30:20 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic427092-357-1.aspxApparently this only effects the SQL log files.I want to eliminate the SQLSTATE 01000 messages from the Backup command when calling it from a SQL Agent job. The output history is almost worthless when you are backing up multiple databases across an entire server.Processed 192 pages for database 'Address1', file 'Address1' on file 1. [SQLSTATE 01000]Processed 1 pages for database 'Address1', file 'Address1_log' on file 1. [SQLSTATE 01000]BACKUP DATABASE successfully processed 193 pages in 0.336 seconds (4.487 MB/sec). [SQLSTATE 01000]Repeated for every database on the server...We only want to see error messages...Can anyone help with this?Tue, 05 Feb 2013 09:59:56 GMTshloghomeshttp://www.sqlservercentral.com/Forums/Topic427092-357-1.aspxGood info !!:)Thu, 29 Nov 2007 04:50:49 GMTMinazhttp://www.sqlservercentral.com/Forums/Topic427092-357-1.aspxYou need to enable traceflag, 3226, this URL may help:http://blogs.msdn.com/sqlserverstorageengine/archive/2007/10/30/when-is-too-much-success-a-bad-thing.aspxWed, 28 Nov 2007 16:02:45 GMTGRE (Gethyn Ellis)http://www.sqlservercentral.com/Forums/Topic427092-357-1.aspxIs there a way to suppress the backup messages during a backup?Processed 256 pages for database 'TestDb', file 'TestDB' on file 5.Processed 1 pages for database 'TestDB', file 'TestDB_log' on file 5.BACKUP DATABASE successfully processed 257 pages in 0.215 seconds (9.792 MB/sec).I want the error messages, just not the 'info' messages.ThanksWed, 28 Nov 2007 14:02:49 GMTSG-348334