Backup DB with no messages

Question

Post reply

Backup DB with no messages

SG-348334

Ten Centuries

Points: 1374
More actions
November 28, 2007 at 2:02 pm

#180861

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

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

GRE (Gethyn Ellis) SSCrazy Eights Points: 9602 More actions · Answer 1

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 Elliswww.gethynellis.com

Minaz Amin SSChampion Points: 11052 More actions · Answer 2

Good info !!:)

"More Green More Oxygen !! Plant a tree today"

shloghomes SSC Rookie Points: 37 More actions · Answer 3

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?

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 4

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.