Home Forums SQL Server 2005 Backups Backup DB with no messages RE: Backup DB with no messages

  • February 5, 2013 at 10:30 am

    #1584513

    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.