network backups fail - error 64

I've found a lot of people with this same problem, but not really any
solutions. We have scheduled backup jobs that run & backup DBs over
the network to a UNC path on our SAN/NAS. A few nights ago, most of
the larger database backups started failing pretty regularly with the
following errors present in the logs.
BackupDiskFile::RequestDurableMedia: failure on backup device
'\\UNCpath\msdb_dump.BAK'. Operating system error 64(The specified
network name is no longer available.)
BACKUP failed to complete the command BACKUP DATABASE msdb TO DISK =
'\\UNCPath\msdb_dump.BAK', WITH INIT, Format
BackupMedium::ReportIoError: write failure on backup device
'\\UNCpath\DB_dump.BAK'. Operating system error 64(The specified
network name is no longer available.).
Internal I/O request 0x26485108: Op: Write, pBuffer: 0x28690000, Size:
983040, Position: 3191806464, UMS: Internal: 0x0, InternalHigh:
0xF0000, Offset: 0xBE3F1A00, OffsetHigh: 0x0, m_buf: 0x28690000, m_len:
983040, m_actualBytes: 0, m_errcode: 64, BackupFile:
\\UNCPath\DB_dump.BAK
I don't know of a good solution here - can anyone help? I don't have
access to the Event Logs on the systems, but I'm trying to get to them,
and I'll repost if I find anything.
Hi,
The OS error 64 usually indicates the intermittent network connectivity
problems.
To ensure that the backups for the database are taken properly, I recommend
you backup to
the local hard disk drive and then create a OS scheduled job to move the
backup file
to the share upon completion of the SQL Backup.
In parallel Inform your network infrastructure team to investigate this
issu. As well as run the below command from command prompt during backup to
check the network issue.
ping <ipaddress_of_remote_machine> -t >pingtest.txt
Once the problem occur verify the pingtest.txt for any Request time Out.
Thanks
Hari
SQL Server MVP
<unc27932@.yahoo.com> wrote in message
news:1121174032.571685.322230@.o13g2000cwo.googlegr oups.com...
> I've found a lot of people with this same problem, but not really any
> solutions. We have scheduled backup jobs that run & backup DBs over
> the network to a UNC path on our SAN/NAS. A few nights ago, most of
> the larger database backups started failing pretty regularly with the
> following errors present in the logs.
> BackupDiskFile::RequestDurableMedia: failure on backup device
> '\\UNCpath\msdb_dump.BAK'. Operating system error 64(The specified
> network name is no longer available.)
> BACKUP failed to complete the command BACKUP DATABASE msdb TO DISK =
> '\\UNCPath\msdb_dump.BAK', WITH INIT, Format
> BackupMedium::ReportIoError: write failure on backup device
> '\\UNCpath\DB_dump.BAK'. Operating system error 64(The specified
> network name is no longer available.).
> Internal I/O request 0x26485108: Op: Write, pBuffer: 0x28690000, Size:
> 983040, Position: 3191806464, UMS: Internal: 0x0, InternalHigh:
> 0xF0000, Offset: 0xBE3F1A00, OffsetHigh: 0x0, m_buf: 0x28690000, m_len:
> 983040, m_actualBytes: 0, m_errcode: 64, BackupFile:
> \\UNCPath\DB_dump.BAK
> I don't know of a good solution here - can anyone help? I don't have
> access to the Event Logs on the systems, but I'm trying to get to them,
> and I'll repost if I find anything.
>
|||How large is your DB?
Do you have any problem when you copy large files, more than 1GB, to the
SAN/NAS?
<unc27932@.yahoo.com> wrote in message
news:1121174032.571685.322230@.o13g2000cwo.googlegr oups.com...
> I've found a lot of people with this same problem, but not really any
> solutions. We have scheduled backup jobs that run & backup DBs over
> the network to a UNC path on our SAN/NAS. A few nights ago, most of
> the larger database backups started failing pretty regularly with the
> following errors present in the logs.
> BackupDiskFile::RequestDurableMedia: failure on backup device
> '\\UNCpath\msdb_dump.BAK'. Operating system error 64(The specified
> network name is no longer available.)
> BACKUP failed to complete the command BACKUP DATABASE msdb TO DISK =
> '\\UNCPath\msdb_dump.BAK', WITH INIT, Format
> BackupMedium::ReportIoError: write failure on backup device
> '\\UNCpath\DB_dump.BAK'. Operating system error 64(The specified
> network name is no longer available.).
> Internal I/O request 0x26485108: Op: Write, pBuffer: 0x28690000, Size:
> 983040, Position: 3191806464, UMS: Internal: 0x0, InternalHigh:
> 0xF0000, Offset: 0xBE3F1A00, OffsetHigh: 0x0, m_buf: 0x28690000, m_len:
> 983040, m_actualBytes: 0, m_errcode: 64, BackupFile:
> \\UNCPath\DB_dump.BAK
> I don't know of a good solution here - can anyone help? I don't have
> access to the Event Logs on the systems, but I'm trying to get to them,
> and I'll repost if I find anything.
>
|||The failing DBs range from 100mb to 8-10gb. I can copy from my client
to the SAN via a mapped network drive to the same share that the DB is
pointing to, just in windows, no problem (it takes forever for the 8gb
file, but it works).
|||Another thing - the backup appears to run OK - using STATS I can view
it progressing but right before it's done it blows up...
A good one says this:
96 percent backed up.
97 percent backed up.
98 percent backed up.
99 percent backed up.
Processed 37680 pages for database 'DB', file 'DB_dat' on file 1.
100 percent backed up.
Processed 1 pages for database 'DB', file 'DB_log' on file 1.
BACKUP DATABASE successfully processed 37681 pages in 22.736 seconds
(13.576 MB/sec).
My bad one says this:
96 percent backed up.
97 percent backed up.
98 percent backed up.
99 percent backed up.
Processed 37680 pages for database 'DB', file 'DB_dat' on file 1.
100 percent backed up.
Processed 1 pages for database 'DB', file 'DB_log' on file 1.
<Then it says something like error 3013, BACKUP DATABASE is terminating
abnormally>

NetApp Filers - Does MS support them, and do they work?

I've posed this before, but never seem to get a concrete answer:
1) Is a Network Appliance NetApp 940 Filer connected via a fiber card
running iSCSI supported by MS for SQL 2000 implementations?
2) Does anyone run a similar configuration and run into problems?
Thanks everyone
1) A snip from the KB below
Windows Hardware Quality Lab (WHQL) Qualified Devices
Microsoft Windows servers and networked servers or NAS storage servers that
are Windows Hardware Quality Lab (WHQL) certified automatically meet the
data write ordering and write-through guarantees required to support a SQL
Server storage device. Microsoft supports both application and
storage-related issues in these configurations.
Other Devices
If you use a non-WHQL qualified storage device with SQL Server that supports
the I/O guarantees for transactional database use described in this article,
Microsoft will provide full support for SQL Server and SQL Server-based
applications.
INF: Support for Network Database Files
http://support.microsoft.com/?kbid=304261
You can check the status of the exact model here
http://www.microsoft.com/windows/catalog/server/
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Gary Klohouse" <fastman@.earthlink.net> wrote in message
news:OfDHJUjfEHA.2812@.tk2msftngp13.phx.gbl...
> I've posed this before, but never seem to get a concrete answer:
> 1) Is a Network Appliance NetApp 940 Filer connected via a fiber card
> running iSCSI supported by MS for SQL 2000 implementations?
> 2) Does anyone run a similar configuration and run into problems?
> Thanks everyone
>
|||they are not great with Sequential Reads.
We use a NetApp filer and are not totally satisfied.
we are moving off to a Hitachi SAN.
Cheers,
Greg Jackson
PDX, Oregon
|||What is happen?
"Gary Klohouse" wrote:

> I've posed this before, but never seem to get a concrete answer:
> 1) Is a Network Appliance NetApp 940 Filer connected via a fiber card
> running iSCSI supported by MS for SQL 2000 implementations?
> 2) Does anyone run a similar configuration and run into problems?
> Thanks everyone
>
>

Nested Sets Tree Structure

Hi,
I need to store a tree using nested sets (http://www.codeproject.com/
database/nestedsets.asp) in SQL Server 2000.
I've got the database sorted, but ive got a problem reading that
data...
I need to get the data out of the database and into an XML structure
in C# (if anyones got a java example or similar i can translate it)
Can anyone point me at any code or tutorials on how to do this? I
really can't think of a sensible way of doing it, but there must be!
Cheers
Andrew
Hi
"trullock@.hotmail.com" wrote:

> Hi,
>
> I need to store a tree using nested sets (http://www.codeproject.com/
> database/nestedsets.asp) in SQL Server 2000.
> I've got the database sorted, but ive got a problem reading that
> data...
> I need to get the data out of the database and into an XML structure
> in C# (if anyones got a java example or similar i can translate it)
> Can anyone point me at any code or tutorials on how to do this? I
> really can't think of a sensible way of doing it, but there must be!
>
> Cheers
> Andrew
>
Check out http://www.perfectxml.com/Articles/XML/ExportSQLXML.asp
and http://sqlxml.org/faqs.aspx?faq=10
John
|||On 16 Feb, 08:25, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Hi
>
> "trull...@.hotmail.com" wrote:
>
>
>
> Check outhttp://www.perfectxml.com/Articles/XML/ExportSQLXML.asp
> andhttp://sqlxml.org/faqs.aspx?faq=10
> John
Thanks, that looks like what I need
I've made another post about nested sets and adjacency lists if you
happen to know anything about them too,
Thanks
Andrew
|||Hi
"trullock@.hotmail.com" wrote:

> On 16 Feb, 08:25, John Bell <jbellnewspo...@.hotmail.com> wrote:
>
> Thanks, that looks like what I need
> I've made another post about nested sets and adjacency lists if you
> happen to know anything about them too,
> Thanks
> Andrew
Joe Celko's book "Trees and Hierarchies in SQL for Smarties" ISBN
1-55860-920-2 has just about everything you need for nested sets and you may
want to Google for his posts.
The parent will be the node with the maximum left value less than the
current node's left value and the minimum right values which is greater than
the current node's right value!
John
|||On 16 Feb, 10:05, John Bell <jbellnewspo...@.hotmail.com> wrote:
> The parent will be the node with the maximum left value less than the
> current node's left value and the minimum right values which is greater than
> the current node's right value!
> John
Cool thanks, think I get that.
Is it possible to do that in a single SQL command, or would I have to
use a user defined function like this:
SELECT Node_ID, Left, Right, fn_FindParent(Node_ID) as ParentID FROM
NODES
Im guessing that will be slow :s
Andrew
|||Hi Andrew
"trullock@.hotmail.com" wrote:

> On 16 Feb, 10:05, John Bell <jbellnewspo...@.hotmail.com> wrote:
>
> Cool thanks, think I get that.
> Is it possible to do that in a single SQL command, or would I have to
> use a user defined function like this:
> SELECT Node_ID, Left, Right, fn_FindParent(Node_ID) as ParentID FROM
> NODES
> Im guessing that will be slow :s
> Andrew
>
There may be other ways to get the parent, the speed would really be
dependent on the size of the hierarchy.
If you wanted to do this in one query it would be (using the ddl from the
article):
SELECT e.EmployeeID,
e.ParentID,
(SELECT f.EmployeeID
FROM Employee f WHERE f.LeftExtent =
(SELECT MAX(g.LeftExtent) FROM Employee g WHERE g.LeftExtent < e.LeftExtent
AND g.RightExtent > e.RightExtent )
AND f.RightExtent =
(SELECT Min(g.RightExtent) FROM Employee g WHERE g.RightExtent >
e.RightExtent AND g.LeftExtent < e.LeftExtent )
)
FROM Employee e
As a function:
CREATE Function dbo.fn_GetLevel ( @.LeftExtent int, @.RightExtent int )
RETURNS INT
AS
BEGIN
RETURN ( SELECT f.EmployeeID
FROM Employee f
WHERE f.LeftExtent =
(SELECT MAX(g.LeftExtent) FROM Employee g WHERE g.LeftExtent <
@.LeftExtent AND g.RightExtent > @.RightExtent )
AND f.RightExtent =
(SELECT Min(g.RightExtent) FROM Employee g WHERE g.RightExtent >
@.RightExtent AND g.LeftExtent < @.LeftExtent )
)
END
SELECT e.EmployeeID,
e.ParentID,
dbo.fn_GetLevel ( e.LeftExtent, e.RightExtent )
FROM Employee e
John
sql