deadlock and Backup 
Author Message
 deadlock and Backup
Is it possible to get an 1205 error (deadlock) from a
client because of a backup running on the server?.

We are running Solomon IV on an SQL2000 in a W2k clustered
server.

Thanks in advance

RT



Sat, 22 May 2004 02:50:53 GMT
 deadlock and Backup

Hi,

Difficult to guess...what does sp_who2 active say?

Dinesh.


Quote:
> Is it possible to get an 1205 error (deadlock) from a
> client because of a backup running on the server?.

> We are running Solomon IV on an SQL2000 in a W2k clustered
> server.

> Thanks in advance

> RT



Sat, 22 May 2004 02:59:31 GMT
 deadlock and Backup
Hard to tell, this was on Sunday.

Quote:
>-----Original Message-----
>Hi,

>Difficult to guess...what does sp_who2 active say?

>Dinesh.



>> Is it possible to get an 1205 error (deadlock) from a
>> client because of a backup running on the server?.

>> We are running Solomon IV on an SQL2000 in a W2k
clustered
>> server.

>> Thanks in advance

>> RT

>.



Sat, 22 May 2004 03:05:15 GMT
 deadlock and Backup
see the articles I refered in previous reply.

This posting is provided ?AS IS? with no warranties, and confers no
rights.

--------------------
| Content-Class: urn:content-classes:message


| Subject: deadlock and Backup
| Date: Mon, 3 Dec 2001 10:50:53 -0800
| Lines: 10

| MIME-Version: 1.0
| Content-Type: text/plain;
|       charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
| Thread-Index: AcF8K29wXpd6dHq9SuS7FfJ2PHbN5A==
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: TKMSFTNGXA10 10.201.226.38
| Path: cpmsftngxa07!cpmsftngxa09!cpmsftngxa06
| Xref: cpmsftngxa07 microsoft.public.sqlserver.server:183768
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Is it possible to get an 1205 error (deadlock) from a
| client because of a backup running on the server?.
|
| We are running Solomon IV on an SQL2000 in a W2k clustered
| server.
|
| Thanks in advance
|
| RT
|
|



Sun, 23 May 2004 17:24:45 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Deadlocked by Deadlocks

2. Deadlock situtation (deadlock victim) - help needed!!

3. Sql Backup using TZ-88 Tape backup

4. Backup from filegroup without transaction log backups

5. Backup single table using file/filegroup backup?

6. Backups - Who shuts down SQL to do backups?

7. Backup Exec Full DB Backup

8. Database backup / database File Backup

9. Question about Transaction log backup with Backup Exec

10. Backup agent or cold backups (SQL 7.0)?

11. Backups: Large full backups fail

12. backup script for deleting backups older than 1 day


 
Powered by phpBB® Forum Software