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
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
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=38 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182979 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
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
Hi Bud, I know programs like Backup Exec used to have a separate SQL module that allowed the db to be backed up while it was open. MSDE is the same engine, so that may still apply. What program are you using? Dan -- Dan O'Keefe TriPoint Technologies [EMAIL PROTECTED] 954.501.3113 |-Original Message- |From: Bud [mailto:[EMAIL PROTECTED]] |Sent: Monday, August 14, 2000 11:51 AM |To: [EMAIL PROTECTED] |Subject: Backing Up SQL | | |Hi all. I'm running MSDE (for now) and when I do my tape backups I'm |getting a sharing violation on the SQL databases. | |I set these databases up as Access Projects and am able to go in and |manually back them up, creating .dat files. Anyone have a solution |that I can use to back these things up with some sort of SQL Query or |other method? | |Thanks, |-- | |Bud Schneehagen - Tropical Web Creations | |_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ |ColdFusion Solutions / eCommerce Development |[EMAIL PROTECTED] |http://www.twcreations.com/ |954.721.3452 |--- |--- |Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ |To Unsubscribe visit |http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_ |talk or send a message to [EMAIL PROTECTED] with |'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Backing Up SQL
I know programs like Backup Exec used to have a separate SQL module that allowed the db to be backed up while it was open. MSDE is the same engine, so that may still apply. What program are you using? i would not use a 3rd party sql server backup even with a gun to my head. *none* of them are really that reliable. its much safer to use tSQL BACKUP dump the database to a file then use a tape backup to backup that. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Backing Up SQL
Hi all. I'm running MSDE (for now) and when I do my tape backups I'm getting a sharing violation on the SQL databases. I set these databases up as Access Projects and am able to go in and manually back them up, creating .dat files. Anyone have a solution that I can use to back these things up with some sort of SQL Query or other method? Thanks, -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
