How about backing up to a local drive, then run a batch file to copy the files from the local drive to the remote drive?
-----Original Message----- From: Brook Davies [mailto:[EMAIL PROTECTED] Sent: Friday, October 29, 2004 4:00 PM To: CF-Talk Subject: Re: backing up SQL Server DB across the network Yes, it does have access. Since the transaction logs are backed up with no problem, and only the large complete DB backup fails, I don't think it is a permission problem... Brook At 12:14 PM 10/29/2004, you wrote: >Do you have SQL Server running under a non-system account with access >rights to the remote NAS? > >Regards, > >Howie > >--- On Friday, October 29, 2004 3:07 PM, Brook Davies scribed: --- > > > > I have a NAS unit and am trying to use it to backup SQL Server DB at > > night. > > I'm using a UNC path as part of the maintenance plan. The problem is > > it seems I can not complete a backup. The backups always fail with > > this error > > message: > > > > BackupDiskFile::RequestDurableMedia: faulre on backup device > > "\\powervault\backup_1\sqldata\". Operating system error 64 (The > > specified network name is no longer available.). > > > > The error only occurs when the database is backed up, the > > transaction logs are backed up to the same UNC path with no problem. > > > > Is it not advisable or even possible to do backups like this? > > > > Brook > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.houseoffusion.com/banners/view.cfm?bannerid=11 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183007 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
