Backup

Home

Backup

Author

Message

Posted Thursday, November 05, 2009 4:59 AM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, October 14, 2010 6:06 AM
Points: 76, Visits: 199

Hi,

how to determine the backup is successfully completed?

Thanks
koteswar Rao

Post #814127

Posted Thursday, November 05, 2009 5:03 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 6:50 AM
Points: 2,719, Visits: 1,065

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.

--------------------------------------------------------------------------------------
Recommended Articles on How to help us help you and
solve commonly asked questions

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

Post #814131

Posted Thursday, November 05, 2009 8:31 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 12:02 PM
Points: 2,581, Visits: 7,295

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.

Post #814307

Permissions