Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Backup DB with no messages Expand / Collapse
Author
Message
Posted Wednesday, November 28, 2007 2:02 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, June 9, 2010 10:58 AM
Points: 140, Visits: 167
Is 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.
Thanks
Post #427092
Posted Wednesday, November 28, 2007 4:02 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 7:04 AM
Points: 1,030, Visits: 2,795
You 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.aspx


Gethyn Ellis

gethynellis.com
Post #427155
Posted Thursday, November 29, 2007 4:50 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, March 11, 2014 3:34 AM
Points: 549, Visits: 1,554
Good info !!:)

"More Green More Oxygen !! Plant a tree today"
Post #427345
Posted Tuesday, February 5, 2013 9:59 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 14, 2014 8:21 AM
Points: 1, Visits: 91
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?

Post #1415969
Posted Tuesday, February 5, 2013 10:30 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 10:02 PM
Points: 23,210, Visits: 31,892
shloghomes (2/5/2013)
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?



My guess, no. Looks like you get this message wether you want it or not.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1415989
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse