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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Backups Running Long

Status
Not open for further replies.

sshafe

Programmer
Oct 18, 2002
71
US
I have a few backups on a server that over the past week, have been running longer that normal. When I say longer, I'm meaning 7 to 8 hours before I kill the process. This db is about 30 GB's and the backup usually runs about 1-2 hours.

I have checked disk space and memory usage on the server and everything looks fine.

Any ideas?

Thanks in advance!!
 
Where are you backing up to? Tape, disk, some other place on the network?

Are you seeing any error(s) in the logs: SQL Server Error logs? Windows Event Logs?

-SQLBill
 
I actually figured it out. I am backing up to tape, and there were no error logs. The job in Enterprise Manager would not end. I ran the command file that the job calls and found it was being prompted for a password and was just waiting on that.

I appreciate your help :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top