dbTalk Databases Forums  

DTS maintenance backup plan failing

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss DTS maintenance backup plan failing in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Kristin
 
Posts: n/a

Default DTS maintenance backup plan failing - 09-12-2003 , 11:22 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
longer available.).

Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: DTS maintenance backup plan failing - 09-12-2003 , 11:31 AM






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

"Kristin" <kristinneibuhr (AT) bc (DOT) com> wrote

Quote:
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
longer available.).



Reply With Quote
  #3  
Old   
Kristin
 
Posts: n/a

Default Re: DTS maintenance backup plan failing - 09-12-2003 , 11:41 AM



RAID 2. I have tried changing the time on the plan, but
it doesn't seem to make a difference.

Quote:
-----Original Message-----
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

"Kristin" <kristinneibuhr (AT) bc (DOT) com> wrote in message
news:002801c3794a$159ce350$a401280a (AT) phx (DOT) gbl...
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
longer available.).


.


Reply With Quote
  #4  
Old   
Sue Hoegemeier
 
Posts: n/a

Default Re: DTS maintenance backup plan failing - 09-12-2003 , 12:42 PM



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"
<kristinneibuhr (AT) bc (DOT) com> wrote:

Quote:
RAID 2. I have tried changing the time on the plan, but
it doesn't seem to make a difference.

-----Original Message-----
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

"Kristin" <kristinneibuhr (AT) bc (DOT) com> wrote in message
news:002801c3794a$159ce350$a401280a (AT) phx (DOT) gbl...
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
longer available.).


.



Reply With Quote
  #5  
Old   
Kristin
 
Posts: n/a

Default Re: DTS maintenance backup plan failing - 09-12-2003 , 03:14 PM



I don't see any errors in event viewer around the time
frames that the backups were running.

Quote:
-----Original Message-----
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"
kristinneibuhr (AT) bc (DOT) com> wrote:

RAID 2. I have tried changing the time on the plan, but
it doesn't seem to make a difference.

-----Original Message-----
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

"Kristin" <kristinneibuhr (AT) bc (DOT) com> wrote in message
news:002801c3794a$159ce350$a401280a (AT) phx (DOT) gbl...
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
longer available.).


.


.


Reply With Quote
  #6  
Old   
Sue Hoegemeier
 
Posts: n/a

Default Re: DTS maintenance backup plan failing - 09-12-2003 , 03:57 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"
<kristinneibuhr (AT) bc (DOT) com> wrote:

Quote:
I don't see any errors in event viewer around the time
frames that the backups were running.

-----Original Message-----
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"
kristinneibuhr (AT) bc (DOT) com> wrote:

RAID 2. I have tried changing the time on the plan, but
it doesn't seem to make a difference.

-----Original Message-----
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

"Kristin" <kristinneibuhr (AT) bc (DOT) com> wrote in message
news:002801c3794a$159ce350$a401280a (AT) phx (DOT) gbl...
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
longer available.).


.


.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.