Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Check BackUP

Status
Not open for further replies.

EscapeUK

Programmer
Jul 7, 2000
438
GB
How can I check that my SQL back-up each night has been successful and that it is not still running during the day.
 
Hi There

In Enterprise Management
Click on your server
Click on Management
Click on SQLSeverAgent
Cilck on Jobs

If the job didnt complete you will get a red error icon beside the job. You can right click it and select "View Job History" to see where it failed. If it is still executing the status column will say "Executing Job".

Hope this helps
Good Luck
Bernadette
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top