
Signature
Hope this helps.
Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/
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?