Backup

• y.koteswarrao-652921

  SSCrazy

  Points: 2010

  More actions

  November 5, 2009 at 4:59 am

  #216445

  Hi,

  how to determine the backup is successfully completed?

  Thanks

  koteswar Rao

• Silverfox

  SSC-Insane

  Points: 23150

  More actions

  November 5, 2009 at 5:03 am

  #1075251

  y.koteswarrao-652921 (11/5/2009)

  ---

  Hi,

  how to determine the backup is successfully completed?

  Thanks

  koteswar Rao

  You can check the sql log as first point of call.

  --------------------------------------------------------------------------------------
  [highlight]Recommended Articles on How to help us help you and[/highlight]
  [highlight]solve commonly asked questions[/highlight]

  Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
  Managing Transaction Logs by Gail Shaw[/url]
  How to post Performance problems by Gail Shaw[/url]
  Help, my database is corrupt. Now what? by Gail Shaw[/url]

• homebrew01

  SSC Guru

  Points: 55548

  More actions

  November 5, 2009 at 8:31 am

  #1075398

  If the job completes successfully, I assume it's ok. Verify the backup file is there. It's good to practice restoring once in a while.