By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,611 Members | 1,711 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,611 IT Pros & Developers. It's quick & easy.

DB Backup error

P: n/a
When backing up a group of DB2 WSE v8.2 databases, I am getting the
following error on one or two backups out of 38 being performed.
"SQL2025N An I/O error "200" occurred on media <target directory
path>". The backups run every night. This error appears about two
times a week. This process is backing up databases from one server
over to another server both with OS Windows 2000 SP4. The destination
drive is a RAID 5 net bay device. The batch job that executes has
been running for years and the only recent change I know of is that
both servers had the Daylight Savings Time patch installed back in
March, 2007. The RAID drives do not indicate a problem visually. At
this point, I have no idea what is causing the failure. Please help.
Thank you!

Jul 3 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Jul 3, 3:08 pm, randi.clau...@illinois.gov wrote:
When backing up a group of DB2 WSE v8.2 databases, I am getting the
following error on one or two backups out of 38 being performed.
"SQL2025N An I/O error "200" occurred on media <target directory
path>". The backups run every night. This error appears about two
times a week. This process is backing up databases from one server
over to another server both with OS Windows 2000 SP4. The destination
drive is a RAID 5 net bay device. The batch job that executes has
been running for years and the only recent change I know of is that
both servers had the Daylight Savings Time patch installed back in
March, 2007. The RAID drives do not indicate a problem visually. At
this point, I have no idea what is causing the failure. Please help.
Thank you!
Did you check the permissions for the dir?

Jul 3 '07 #2

P: n/a
ra***********@illinois.gov wrote:
When backing up a group of DB2 WSE v8.2 databases, I am getting the
following error on one or two backups out of 38 being performed.
"SQL2025N An I/O error "200" occurred on media <target directory
path>". The backups run every night. This error appears about two
times a week. This process is backing up databases from one server
over to another server both with OS Windows 2000 SP4. The destination
drive is a RAID 5 net bay device. The batch job that executes has
been running for years and the only recent change I know of is that
both servers had the Daylight Savings Time patch installed back in
March, 2007. The RAID drives do not indicate a problem visually. At
this point, I have no idea what is causing the failure. Please help.
Thank you!
Given your description of the problem my best guess is network problems.
Check whether the network connection dropped at the time of the backup
that failed.
/Lennart
Jul 3 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.