Database backup option, stats =

• Juanita

  SSCertifiable

  Points: 5300

  More actions

  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

• John Rowan

  SSC Guru

  Points: 56440

  More actions

  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

• Juanita

  SSCertifiable

  Points: 5300

  More actions

  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