Groups | Blog | Home
all groups > sql server dts > september 2003 >

sql server dts : DTS maintenance backup plan failing


Kristin
9/12/2003 9:22:39 AM
I am backing up 2 databases and sending the files/reports
to another server. I have requested that backup files be
deleted that are > 1 day, and report files > 1 week.
Occasionally it fails with the following error, and I
don't know why. Has anybody seen this before?

BackupDiskFile::RequestDurableMedia: failure on backup
device '\\WWSFP1\Data\Backup\WWDB1_db_200309112200.BAK'.
Operating system error 64(The specified network name is no
Kristin
9/12/2003 9:41:05 AM
RAID 2. I have tried changing the time on the plan, but
it doesn't seem to make a difference.

[quoted text, click to view]
Sue Hoegemeier
9/12/2003 11:42:37 AM
I'd go with Allan's first guess. Have you checked the
Windows event logs for network related warnings or errors?
Any redirector timeouts?

-Sue

On Fri, 12 Sep 2003 09:41:05 -0700, "Kristin"
[quoted text, click to view]
Kristin
9/12/2003 1:14:21 PM
I don't see any errors in event viewer around the time
frames that the backups were running.

[quoted text, click to view]
Sue Hoegemeier
9/12/2003 2:57:39 PM
If you checked the SQL Server server, the destination server
and the DC for errors and didn't find anything, I don't know
what else to suggest but for whatever reason, you lose your
connectivity to the other server which is typically network
related.

-Sue

On Fri, 12 Sep 2003 13:14:21 -0700, "Kristin"
[quoted text, click to view]
Allan Mitchell
9/12/2003 5:31:14 PM
It sounds like your network has a glitch every now and then OR is the
destination a RAID 5 array ? It could be that writing the large files to
this disk subsystem is causing it to hiccup.



--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

[quoted text, click to view]

AddThis Social Bookmark Button