|
Posted by pb648174 on 05/15/06 17:51
I added seconds and got the same "Timeout expired" error for 3 backups
in a row, with the backups happening every two hours. The issue went
away by the time the 4th backup (8 hours later) came up. The output is
below with time.
10:00:00.43
Timeout expired
10:00:16.35
The interesting thing is that there are two production SQL 2005 servers
and one backup SQL 2005 server. Here is how they were affected during
the three failed backups, two hours between each, with no loss of
connectivity for users using the application. The duration between
start and end for the failure is pretty consistently about 16 seconds
as in the above error message.
production1 production2 backup
10am down up down
12pm down down down
02pm down up up
Navigation:
[Reply to this message]
|