Event Viewer error during the the Backup job!!

Question

Event Viewer error during the the Backup job!!

madhu-686862

SSChampion

Points: 10707
More actions
April 14, 2009 at 11:29 am

#208248

Hi,
Iam getting the following Event viewer error daily at the time full backup job is running. Please tell me what will be the issue
Event Type:Error
Event Source:dpti2o
Event Category:None
Event ID:9
Date:4/13/2009
Time:10:01:32 AM
User:N/A
Computer:ABC
Description:
The device, \Device\Scsi\dpti2o1, did not respond within the timeout period.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

Are you backing up directly to tape? Can you post the Backup command?

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

maechismo_8514 SSCoach Points: 17510 More actions · Answer 2

I doubt its something related to network error. As advised could you please post your backup command and also where you are backing up this to ? Local/network/tape?

madhu-686862 SSChampion Points: 10707 More actions · Answer 3

Thanks,

Iam taking the backups directly to the local drive in the server. Iam using the below procedure for backups.

USE [master]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE BackupDB

@DBName VARCHAR(100),

@BackupPath VARCHAR(2000),

@BackupType VARCHAR(4) = 'FULL'

AS

BEGIN

DECLARE @BackupName VARCHAR(255)

DECLARE @Prefix VARCHAR(50)

DECLARE @backupSetId AS INT

IF NOT EXISTS (SELECT 1 FROM master.dbo.sysdatabases WHERE name = @DBName)

BEGIN

SELECT 'Database name does not exist'

RETURN(1)

END

IF @DBName = 'tempdb'

BEGIN

SELECT 'tempdb cannot be backedup'

RETURN(1)

END

IF @BackupType NOT IN ('FULL', 'LOG', 'DIFF')

BEGIN

PRINT 'Invalid type of Backup selected, only FULL and LOG backup is allowed'

RETURN(1)

END

IF RIGHT(@BackupPath,1) <> '\'

SET @BackupPath = @BackupPath + '\'

IF @BackupType = 'FULL'

BEGIN

SET @BackupName = @DBName + ' Full Backup'

SET @BackupPath = @BackupPath + @DBName +'_'+ CONVERT(VARCHAR(10),GETDATE(),110)+'.bak'

SELECT @BackupPath AS Full_BackupPath_of_The_Database

BACKUP DATABASE @DBName

TO DISK = @BackupPath

WITH NOFORMAT, NOINIT, NAME = @BackupName,

SKIP, NOREWIND, NOUNLOAD, STATS = 10

SELECT @backupSetId = position FROM msdb..backupset WHERE database_name= @DBName

AND backup_set_id=(SELECT MAX(backup_set_id) FROM msdb..backupset

WHERE database_name = @DBName )

IF @backupSetId IS NULL

BEGIN

RAISERROR (N'Verify failed for database', 16, 1)

END

RESTORE VERIFYONLY

FROM DISK = @BackupPath

WITH FILE = @backupSetId, NOUNLOAD, NOREWIND

END

IF @BackupType = 'DIFF'

BEGIN

SET @BackupName = @DBName + ' Differential Backup'

SELECT @Prefix = CONVERT(VARCHAR(50), GETDATE(),120)

SELECT @Prefix = REPLACE(@Prefix, '-', '')

SELECT @Prefix = REPLACE(@Prefix, ':', '')

SELECT @Prefix = REPLACE(@Prefix, ' ', '')

SET @BackupPath = @BackupPath + @DBName + '_' + @Prefix +'.bak'

SELECT @BackupPath AS Diff_Backup_Path

BACKUP DATABASE @DBName

TO DISK = @BackupPath

WITH DIFFERENTIAL ,NOFORMAT, INIT, NAME = @BackupName,

SKIP, NOREWIND, NOUNLOAD, STATS = 10

SELECT @backupSetId = position FROM msdb..backupset WHERE database_name= @DBName

AND backup_set_id=(SELECT MAX(backup_set_id) FROM msdb..backupset

WHERE database_name = @DBName )

IF @backupSetId IS NULL

BEGIN

RAISERROR (N'Verify failed for database', 16, 1)

END

RESTORE VERIFYONLY

FROM DISK = @BackupPath

WITH FILE = @backupSetId, NOUNLOAD, NOREWIND

END

IF @BackupType = 'LOG'

BEGIN

SELECT @Prefix = CONVERT(VARCHAR(50), GETDATE(),120)

SELECT @Prefix = REPLACE(@Prefix, '-', '')

SELECT @Prefix = REPLACE(@Prefix, ':', '')

SELECT @Prefix = REPLACE(@Prefix, ' ', '')

SET @BackupName = @DBName + ' Log Backup'

SET @BackupPath = @BackupPath + @DBName + '_Log' + @Prefix + '.trn'

SELECT @BackupPath AS Log_Backup_Path

BACKUP log @DBName

TO DISK = @BackupPath

WITH NOFORMAT, NOINIT, NAME = @BackupName,

SKIP, NOREWIND, NOUNLOAD, STATS = 10

SELECT @backupSetId = position FROM msdb..backupset WHERE database_name= @DBName

AND backup_set_id=(SELECT MAX(backup_set_id) FROM msdb..backupset

WHERE database_name = @DBName )

IF @backupSetId IS NULL

BEGIN

RAISERROR (N'Verify failed for database', 16, 1)

END

RESTORE VERIFYONLY

FROM DISK = @BackupPath

WITH FILE = @backupSetId, NOUNLOAD, NOREWIND

END

Please advice me is there anything wrong with the procedure or its related to disk error?

Iam getting this error only once in a day while full backup is running.

Thanks

madhu-686862 SSChampion Points: 10707 More actions · Answer 4

Hi,

changed the full backup schedule 1 hr later, then also Iam getting the same error while backup is running

Could you please give some idea on how to diagnose this

thanks

philcart SSC-Forever Points: 47794 More actions · Answer 5

I believe \Device\Scsi\dpti2o1 refers to an array adaptor.

Check if the adaptor has the latest firmware/drivers/etc...

--------------------
Colt 45 - the original point and click interface

madhu-686862 SSChampion Points: 10707 More actions · Answer 6

Hi,

We changed the setting in registry HKLM\System\CurrentControlSet\Services\Disk\TimeOutValue=30 (dword)

and updated the controller drivers with latest version. But still we are getting the same error.

any thoughts....