Backup DB with no messages

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Backups » Backup DB with no messages

Backup DB with no messages

Rate Topic

Display Mode

Topic Options

Author

Message

SG-348334

Posted Wednesday, November 28, 2007 2:02 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, June 09, 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

GRE (Gethyn Ellis)

Posted Wednesday, November 28, 2007 4:02 PM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 9:55 AM
Points: 1,024, Visits: 2,768

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

Minaz

Posted Thursday, November 29, 2007 4:50 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Sunday, April 21, 2013 10:57 PM
Points: 535, Visits: 1,423

Good info !!:)

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

Post #427345

shloghomes

Posted Tuesday, February 05, 2013 9:59 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, April 29, 2013 7:35 AM
Points: 1, Visits: 68

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

Lynn Pettis

Posted Tuesday, February 05, 2013 10:30 AM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 12:22 AM
Points: 21,588, Visits: 27,384

shloghomes (2/5/2013)

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

Cool

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 »

Permissions