Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / DB Engine / SQL Server / July 2008

Tip: Looking for answers? Try searching our database.

Problems Backing up SQL 2000 over the network...

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
DarrenW - 11 Jul 2008 11:29 GMT
The Problem:

I'm trying to backup a SQL2000 cluster over the network using 2 maintenance
plans, one for 'simple' recovery DB's and one for 'Full'.

However for different databases I'm getting a mix of the following problems:

Event Type:       Error
Event Source:    MSSQLSERVER
Event Category: (2)
Event ID:           17055
Date:                10/07/08
Time:               20:04:48
User:                xxxx.xxxxx\SQLAdmin
Computer:        xxxxxSQLSVRxx
Description:
18210 :
BackupDiskFile::RequestDurableMedia:  failure on backup device
'\\xxxxxxx\d$\SQL_Backups\xxxxxQLSVRxx\FirstClass\FirstClass_db_200807102001.BAK'. Operating system error 64(error not found).

and

Event Type:        Error
Event Source:     MSSQLSERVER
Event Category:  (6)
Event ID:           17055
Date:                10/07/08
Time:                20:04:48
User:                xxxx.xxxxx\SQLAdmin
Computer:        xxxxxSQLSVRxx
Description:
3041 :
BACKUP failed to complete the command BACKUP DATABASE [exchangeDB] TO  DISK
=
N'\\xxxxxx\d$\SQL_Backups\xxxxSQLSVRxx\exchangeDB\exchangeDB_db_200807102001.BAK' WITH  INIT ,  NOUNLOAD ,  NOSKIP ,  STATS = 10,  NOFORMAT

and

Event Type:        Error
Event Source:     MSSQLSERVER
Event Category:  (2)
Event ID:           17055
Date:                10/07/08
Time:                20:04:48
User:                xxxx.xxxxxx\SQLAdmin
Computer:         xxxxSQLSVRxx
Description:
18210 :
BackupMedium::ReportIoError: write failure on backup device
'\\xxxxxxx\d$\SQL_Backups\xxxxSQLSVRxx\exchangeDB\exchangeDB_db_200807102001.BAK'. Operating system error 64(error not found).

Once I've censored the local details of the SQL log I'll post that as well.

Some of the (smaller) DB's covered by the same plans are in deed backing up
nicely, which adds to my confusion. I think the errors are stopping the job
from continuing so that the clean-up process of deleting older files isn't
running for any DB's.

My System:
Windows 2003 Enterprise Sp2 Cluster
Running SQL 2000 Enterprise sp4
2 Nodes - Using a FC connected 'HP MSA1500' as shared storage, trying to
copy to a Windows 2003 Enterprise sp1 server using a local attached SCSI
array.

Neither SQL nodes are running any AV products.

What I have tried so far:
Split the maintenance plans between 'simple' & 'full' recovery mode DB's. I
know they can be a bit bugged when covered by the same maintenance plan.
Ensured that the 'SQLAdmin' account has full control on the destination
files & folders.
Found & then discounted the following KB article as the version of the Hot
Fix has been superseded by a later Service Pack.
http://support.microsoft.com/kb/843515

I haven't tried creating a Share on the backup server, I was going to try
that next to see if that made any difference.

If anyone can dispense some wisdom to try & solve this I would be Hugely
Grateful.
Thank you in advance.
LeoPasta - 11 Jul 2008 12:03 GMT
Hi,
 Although you have checked it already, I would double-check if your
SQLAdmin account indeed has write permissions when writing through the d$
network share. Creating a specific share and setting the appropriate
permissions will probably be the best way to go, if possible.

Regards,
LeoPasta

> The Problem:
>
[quoted text clipped - 88 lines]
> Grateful.
> Thank you in advance.
DarrenW - 11 Jul 2008 15:23 GMT
Hi Leo,

Thanks for your idea, I did double check...

The default D$ share just that, it has no special security. However at NTFS
level I added the SQLAdmin account. But it doesn't appear to make any
difference.

While I was there I triple checked it had access to the subfolder targets
that I want to specify, and it does have Full Control.

Any other ideas would be gratefully received.

> Hi,
>   Although you have checked it already, I would double-check if your
[quoted text clipped - 4 lines]
> Regards,
> LeoPasta
Dan Guzman - 11 Jul 2008 12:20 GMT
> BackupDiskFile::RequestDurableMedia:  failure on backup device
> '\\xxxxxxx\d$\SQL_Backups\xxxxxQLSVRxx\FirstClass\FirstClass_db_200807102001.BAK'.
> Operating system error 64(error not found).

From the command prompt, NET HELPMSG 64 returns "The specified network name
is no longer available."

I think this indicates an underlying network issue.  Can you copy large
files manually from the SQL Server to the backup server using a UNC path?

Signature

Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

> The Problem:
>
[quoted text clipped - 88 lines]
> Grateful.
> Thank you in advance.
DarrenW - 11 Jul 2008 14:37 GMT
Thanks for responding Dan,

I have tested file copying to & from the servers in question with no sign of
any problems.

However I did try to do a one off backup on the largest DB on the SQL server
(its a test DB).
and got the following errors when trying to launch the backup using a backup
device, pointing to the network path, or using the path directly when trying
a backup task . Any clues??

2008-07-11 14:22:03.04 spid104   BackupDiskFile::CreateMedia: Backup device
'\\xxxBUPSVRxxx\d$\SQL_Backups\Test_Backups' failed to create. Operating
system error = 5(error not found).
2008-07-11 14:22:03.04 backup    BACKUP failed to complete the command
BACKUP DATABASE [Progress] TO  DISK =
N'\\xxxBUPSVRxxx\d$\SQL_Backups\Test_Backups' WITH  NOINIT ,  NOUNLOAD ,  
NAME = N'Progress backup Test',  NOSKIP ,  STATS = 10,  NOFORMAT
2008-07-11 14:22:09.77 spid104   BackupDiskFile::OpenMedia: Backup device
'\\xxxBUPSVRxxx\d$\SQL_Backups\Test_Backups' failed to open. Operating system
error = 5(error not found).
2008-07-11 14:22:12.00 spid104   BackupDiskFile::OpenMedia: Backup device
'\\xxxBUPSVRxxx\d$\SQL_Backups\Test_Backups' failed to open. Operating system
error = 5(error not found).
2008-07-11 14:22:35.74 spid104   BackupDiskFile::CreateMedia: Backup device
'\\xxxBUPSVRxxx\d$\SQL_Backups\Test_Backups' failed to create. Operating
system error = 5(error not found).
2008-07-11 14:22:35.74 backup    BACKUP failed to complete the command
BACKUP DATABASE [Progress] TO  DISK =
N'\\xxxBUPSVRxxx\d$\SQL_Backups\Test_Backups' WITH  INIT ,  NOUNLOAD ,  NAME
= N'Progress backup Test',  NOSKIP ,  STATS = 10,  NOFORMAT
2008-07-11 14:25:31.13 spid104   BackupDiskFile::CreateMedia: Backup device
'\\xxxBUPSVRxxx\d$\SQL_Backups\Test_Backups' failed to create. Operating
system error = 5(error not found).
2008-07-11 14:25:31.13 backup    BACKUP failed to complete the command
BACKUP DATABASE [Progress] TO [Backup Test] WITH  INIT ,  NOUNLOAD ,  NAME =
N'Progress backup',  NOSKIP ,  STATS = 10,  NOFORMAT

> > BackupDiskFile::RequestDurableMedia:  failure on backup device
> > '\\xxxxxxx\d$\SQL_Backups\xxxxxQLSVRxx\FirstClass\FirstClass_db_200807102001.BAK'.
[quoted text clipped - 5 lines]
> I think this indicates an underlying network issue.  Can you copy large
> files manually from the SQL Server to the backup server using a UNC path?
Tibor Karaszi - 11 Jul 2008 16:59 GMT
Open a "DOS" prompt and type below:

NET HELPMSG 5

You will see it means "Access Denied". So apparently the SQL Server service account do not have
needed permissions on the share you specified.

Signature

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

> Thanks for responding Dan,
>
[quoted text clipped - 43 lines]
>> I think this indicates an underlying network issue.  Can you copy large
>> files manually from the SQL Server to the backup server using a UNC path?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.