Post reply

Scripted Backup pesky statistics print

  • June 3, 2011 at 10:23 am

    #252259

    I'm going crazy with this.

    When I script a backup it displays the stats in messages. e.g

    Processed 4792 pages for database 'Blah', file 'Blah' on file 1.

    Processed 2 pages for database 'Blah', file 'Blah_log' on file 1.

    BACKUP DATABASE successfully processed 4794 pages in 3.258 seconds (12.053 MB/sec).

    Very useful....

    Unless you're trying to configure an ADO solution and each line of message is automatically interpreted as an error.

    I just want to turn this message off. Any help would be greatly appreciated.

    Many thanks 🙂

  • June 3, 2011 at 12:20 pm

    #1333865

    I'm thinking you are going to have to catch them and evaluate whether they are true errors. I did a little search online and didn't see a way around it. Also, I have never seen a way to suppress those messages.

    Sorry.

    CEWII

  • June 9, 2011 at 11:01 am

    #1336537

    We have scripted backups that run as SQL Jobs via Litespeed and we never see those messages.

    Does the ADO need to run the script itself or can it just trigger a SQL Agent Job?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • June 14, 2011 at 4:53 am

    #1338262

    Ahh, Server Agent!! Perfect, thanks! 😀

  • June 14, 2011 at 5:27 am

    #1338273

    Glad I could help.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

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