aarich event error when backup is run on big DB

Hi all...
Let me first explain why I posted this here... I have run this error
past Microsoft and Gigabyte, and both cant help me, so now I'm turning
to you guys :-) What happens is that I got a job set up on SQL
Enterprise 2000 that runs a backup of one of the several DB's on the
server. But in 90% of the times that the backup run, this event log
starts appearing, and consistently repeats, until the pc eventually
freezes up and I have to do a hard restart. I'm starting to think that
it has something to do with the DB size... its about 5+ gig and also
the backup. This has only recently started to happen, and I'm also
thinking it because the DB increased in size. The other DB's backs up
fine, but none of them is bigger than 500Meg. Here's some additional
info
OS: Windows Server 2003 SE SP1
CPU: Intel Pentium 4 3GHz
Mem: 1Gig
Motherboard: Gigabyte GA-8IKHXT(1.0)
I got 2 HD's running Raid 1 (mirroring), thus I first thought it might
be that, cause the file below is the drivers for it.
Event Error:
Event Type: Error
Event Source: aarich
Event Category: None
Event ID: 9
Date: 18/05/2006
Time: 11:23:01
User: N/A
Computer: ACCOUNTS
Description:
The device, \Device\Scsi\aarich1, did not respond within the timeout
period.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 00 00 10 00 01 00 66 00 .....f.
0008: 00 00 00 00 09 00 04 c0 ......=C0
0010: 01 01 00 50 00 00 00 00 ...P...
0018: 00 00 00 00 00 00 00 00 ......
0020: 00 00 00 00 00 00 00 00 ......
0028: 00 00 00 00 00 00 00 00 ......
0030: 00 00 00 00 07 00 00 00 ......
I was thinking of maybe running something that could reduce the size of
my DB, but I'm a bit hesitant on fiddling with this DB, as it is my
companies accounts DB.
Any suggestions or advise or questions?Friendly wrote:
> Hi all...
> Let me first explain why I posted this here... I have run this error
> past Microsoft and Gigabyte, and both cant help me, so now I'm turning
> to you guys :-) What happens is that I got a job set up on SQL
> Enterprise 2000 that runs a backup of one of the several DB's on the
> server. But in 90% of the times that the backup run, this event log
> starts appearing, and consistently repeats, until the pc eventually
> freezes up and I have to do a hard restart. I'm starting to think that
> it has something to do with the DB size... its about 5+ gig and also
> the backup. This has only recently started to happen, and I'm also
> thinking it because the DB increased in size. The other DB's backs up
> fine, but none of them is bigger than 500Meg. Here's some additional
> info
> OS: Windows Server 2003 SE SP1
> CPU: Intel Pentium 4 3GHz
> Mem: 1Gig
> Motherboard: Gigabyte GA-8IKHXT(1.0)
> I got 2 HD's running Raid 1 (mirroring), thus I first thought it might
> be that, cause the file below is the drivers for it.
> Event Error:
> Event Type: Error
> Event Source: aarich
> Event Category: None
> Event ID: 9
> Date: 18/05/2006
> Time: 11:23:01
> User: N/A
> Computer: ACCOUNTS
> Description:
> The device, \Device\Scsi\aarich1, did not respond within the timeout
> period.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> Data:
> 0000: 00 00 10 00 01 00 66 00 .....f.
> 0008: 00 00 00 00 09 00 04 c0 ......À
> 0010: 01 01 00 50 00 00 00 00 ...P...
> 0018: 00 00 00 00 00 00 00 00 ......
> 0020: 00 00 00 00 00 00 00 00 ......
> 0028: 00 00 00 00 00 00 00 00 ......
> 0030: 00 00 00 00 07 00 00 00 ......
>
> I was thinking of maybe running something that could reduce the size of
> my DB, but I'm a bit hesitant on fiddling with this DB, as it is my
> companies accounts DB.
> Any suggestions or advise or questions?
>
Hi
A 5 Gb database isn't very big and shouldn't give you any problems with
regards to backing it up. From error message, it sounds to me like the
problem is with one of your harddrives. Have you tried to backup the
database to another location e.g. a network location? This would rule
out that the problem is related to the path where you put your backup.
--
Regards
Steen Schlüter Persson
DBA|||Thanks for the fast reply. I tried backing up to 2 mapped network
drives, but both give me the below error... once again Microsoft
doesn't know what this is :-( If this is something to do with
permissions, then I'm lost, cause both mapped drives on both pc's has
the shares and security set to 'everyone'.
I will get my external USB drive in on Monday, then I'll try it with
that HD and report back.
Here's the error I got when trying to back up to a mapped drive.
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 09/06/2006
Time: 14:49:36
User: NT AUTHORITY\SYSTEM
Computer: ACCOUNTS
Description:
18204 :
BackupDiskFile::CreateMedia: Backup device 'F:\Perry\aa1900.bak' failed
to create. Operating system error = 3(error not found).
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 1c 47 00 00 10 00 00 00 .G.....
0008: 09 00 00 00 41 00 43 00 ...A.C.
0010: 43 00 4f 00 55 00 4e 00 C.O.U.N.
0018: 54 00 53 00 00 00 00 00 T.S....
0020: 00 00 ..|||OS error 3 is "The system cannot find the path specified.". Is this a local disk? Is it a regular
disk?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Friendly" <friendly_781114@.hotmail.com> wrote in message
news:1149861850.904118.98290@.i40g2000cwc.googlegroups.com...
> Thanks for the fast reply. I tried backing up to 2 mapped network
> drives, but both give me the below error... once again Microsoft
> doesn't know what this is :-( If this is something to do with
> permissions, then I'm lost, cause both mapped drives on both pc's has
> the shares and security set to 'everyone'.
> I will get my external USB drive in on Monday, then I'll try it with
> that HD and report back.
> Here's the error I got when trying to back up to a mapped drive.
> Event Type: Error
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17055
> Date: 09/06/2006
> Time: 14:49:36
> User: NT AUTHORITY\SYSTEM
> Computer: ACCOUNTS
> Description:
> 18204 :
> BackupDiskFile::CreateMedia: Backup device 'F:\Perry\aa1900.bak' failed
> to create. Operating system error = 3(error not found).
>
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> Data:
> 0000: 1c 47 00 00 10 00 00 00 .G.....
> 0008: 09 00 00 00 41 00 43 00 ...A.C.
> 0010: 43 00 4f 00 55 00 4e 00 C.O.U.N.
> 0018: 54 00 53 00 00 00 00 00 T.S....
> 0020: 00 00 ..
>|||Tibor Karaszi wrote:
> OS error 3 is "The system cannot find the path specified.". Is this a local disk? Is it a regular
> disk?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
This second error has nothing to do with the original issue. The second
error happened when I tried doing a backup to a mapped drive, which is
mapped to another server on the same network. I tried it with another
mapped drive to another server, and same error came up when running the
backup job. Now because this error probably hasn't anything to do with
the original error, I will be getting in my external USB HD on Monday,
and then try and back up to that drive and report what happens then.
I just want to repeat this, that the original error only happens 90% of
the time to one of the 6 DB's I got running on the pc. The only
noticable difference between the DB that gives the errors, and the rest
is the size.|||"Friendly" <friendly_781114@.hotmail.com> wrote in message
news:1149840272.386673.84020@.g10g2000cwb.googlegroups.com...
Hi all...
Let me first explain why I posted this here... I have run this error
past Microsoft and Gigabyte, and both cant help me, so now I'm turning
to you guys :-) What happens is that I got a job set up on SQL
Enterprise 2000 that runs a backup of one of the several DB's on the
server. But in 90% of the times that the backup run, this event log
starts appearing, and consistently repeats, until the pc eventually
freezes up and I have to do a hard restart. I'm starting to think that
it has something to do with the DB size... its about 5+ gig and also
the backup. This has only recently started to happen, and I'm also
thinking it because the DB increased in size. The other DB's backs up
fine, but none of them is bigger than 500Meg. Here's some additional
info
>>>>>>>>>>>>>
Could be a couple of things.
Bad spot(s) on the disk where the controller keeps retrying until it times
out.
Could be an issue with the cache on the controller. Check to see if it's in
write-back or write-thru, change to write-thru.
Try putting a separate physical disk in the machine and backing up to that.
Also try stopping the database and do a manual xcopy to another location.
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
OS: Windows Server 2003 SE SP1
CPU: Intel Pentium 4 3GHz
Mem: 1Gig
Motherboard: Gigabyte GA-8IKHXT(1.0)
I got 2 HD's running Raid 1 (mirroring), thus I first thought it might
be that, cause the file below is the drivers for it.
Event Error:
Event Type: Error
Event Source: aarich
Event Category: None
Event ID: 9
Date: 18/05/2006
Time: 11:23:01
User: N/A
Computer: ACCOUNTS
Description:
The device, \Device\Scsi\aarich1, did not respond within the timeout
period.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 00 00 10 00 01 00 66 00 .....f.
0008: 00 00 00 00 09 00 04 c0 ......À
0010: 01 01 00 50 00 00 00 00 ...P...
0018: 00 00 00 00 00 00 00 00 ......
0020: 00 00 00 00 00 00 00 00 ......
0028: 00 00 00 00 00 00 00 00 ......
0030: 00 00 00 00 07 00 00 00 ......
I was thinking of maybe running something that could reduce the size of
my DB, but I'm a bit hesitant on fiddling with this DB, as it is my
companies accounts DB.
Any suggestions or advise or questions?|||It appears like there is much I/O delay. Are you taking the backup to the
mirrored disk? Can you try the backup to non mirrored disk? Also check with
the hardware vendor..Try with a high speed disk
Jayesh
"Friendly" <friendly_781114@.hotmail.com> wrote in message
news:1149840272.386673.84020@.g10g2000cwb.googlegroups.com...
Hi all...
Let me first explain why I posted this here... I have run this error
past Microsoft and Gigabyte, and both cant help me, so now I'm turning
to you guys :-) What happens is that I got a job set up on SQL
Enterprise 2000 that runs a backup of one of the several DB's on the
server. But in 90% of the times that the backup run, this event log
starts appearing, and consistently repeats, until the pc eventually
freezes up and I have to do a hard restart. I'm starting to think that
it has something to do with the DB size... its about 5+ gig and also
the backup. This has only recently started to happen, and I'm also
thinking it because the DB increased in size. The other DB's backs up
fine, but none of them is bigger than 500Meg. Here's some additional
info
OS: Windows Server 2003 SE SP1
CPU: Intel Pentium 4 3GHz
Mem: 1Gig
Motherboard: Gigabyte GA-8IKHXT(1.0)
I got 2 HD's running Raid 1 (mirroring), thus I first thought it might
be that, cause the file below is the drivers for it.
Event Error:
Event Type: Error
Event Source: aarich
Event Category: None
Event ID: 9
Date: 18/05/2006
Time: 11:23:01
User: N/A
Computer: ACCOUNTS
Description:
The device, \Device\Scsi\aarich1, did not respond within the timeout
period.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 00 00 10 00 01 00 66 00 .....f.
0008: 00 00 00 00 09 00 04 c0 ......À
0010: 01 01 00 50 00 00 00 00 ...P...
0018: 00 00 00 00 00 00 00 00 ......
0020: 00 00 00 00 00 00 00 00 ......
0028: 00 00 00 00 00 00 00 00 ......
0030: 00 00 00 00 07 00 00 00 ......
I was thinking of maybe running something that could reduce the size of
my DB, but I'm a bit hesitant on fiddling with this DB, as it is my
companies accounts DB.
Any suggestions or advise or questions?|||Hi all... Thanks for the replies so far. Sorry for not coming back
sooner, but been busy with some other stuff. I came in to work over the
weekend and successfully backed up the DB on a USB drive 3 times, 2
hours apart. And I didn't get any event errors. To answer the previous
person's question, I am backing up to a mirrorred drive yes. But it was
backing up to the same hardware configuration a few months ago, without
any event errors... which sort of makes me believe that this could be
one of the hard drives failing?
Any further advice or tests you want me to do?
Thanks