question

Cheton avatar image
Cheton asked

The Sql server 2005 system hangs after backup The database and before sending the confirmation email

Sql server 2005 system hangs after backup the database and before sending the confirmation email. This problem occurs randomly. The Back-up process consists of an incremental backup copy daily and one complete weekly the Sunday
sql-server-2005backup
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

In addition to the requests for error messages, can I also ask what you're using to do the backup?
0 Likes 0 ·
ramesh 1 avatar image
ramesh 1 answered
any error in the sql server error logs or event veiwer
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image
Grant Fritchey answered
Without an error message, it's hard to say. Guessing, I would think it's more likely that it's a problem caused by however you're sending the email rather than the backup process. I don't see backups causing system problems in the work I do. I would check the location where your backups are going to see if the backup completed. As @Ramesh 1 says, check the error logs, system, sql server and sql agent (three different logs). Can you query the system at all? Look at sys.dm_exec_requests to see if there are system processes blocked or waiting and understand what is causing them to stop.
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Sorry - just corrected Ramesh to @Ramesh 1.
0 Likes 0 ·
Not a problem. Thanks.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.