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
