Post reply

Database backup option, stats =

  • July 22, 2009 at 2:18 pm

    #385034

    Hello,

    I am looking at a database backup command that is executed via the maintenance plan. the backup command has the stats = 10 optoin. I read in BOL that it means "Displays a message each time another percentage completes, and is used to gauge progress. If percentage is omitted, SQL Server displays a message after each 10 percent is completed."

    Where is this message displayed? Is it recommended to use this option?

    thanks,

    Juanita

  • July 22, 2009 at 2:21 pm

    #1028669

    I'm not sure if it would be displayed anywhere when used via a maintenance plan. Maybe if your plan is set up to log the results to a file, you'd see the results there. I like to use the STATS option when running RESTORE commands via SSMS so that I know what my progress looks like.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • July 22, 2009 at 2:48 pm

    #1028684

    HI,

    Thank you so much... I ran the backup in query analyzer and see the messages.. looked in the output file that the maintenance plan creates and no messages there. But at least now I know messages do exist.

    Juanita

Viewing 3 posts - 1 through 2 (of 2 total)

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