Re: backing up SQL Server DB across the network
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 > > > > > ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=36 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182980 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
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 > > > > > > > > > > > > ~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182988 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: backing up SQL Server DB across the network
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
RE: backing up SQL Server DB across the network
This is common, if not universal when backing up DBs from a maintenance plan across the network. There are two choices to make this more reliable. Do your maintenance plan backup locally, then either use backup software to write it to the NAS (you don't need hot DB backup add-ons), or open the backup folder on the DB machine to the NAS - read only is fine - and pull it onto the NAS with a script. You can set your maintenance plan to limit the number of days of backup that it holds in the target folder, so there is no added human intervention needed. Cary Gordon The Cherry Hill Company -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED] Sent: Friday, October 29, 2004 12:07 PM To: CF-Talk Subject: OT: backing up SQL Server DB across the network 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 ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183063 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
