Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Error on Backup to Netweork Location


Error on Backup to Netweork Location

Author
Message
Jack Corbett
  Jack Corbett
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: General Forum Members
Points: 11014 Visits: 14858

I have a database, about 7GB, that I am attempting to backu pacross the network to a Firewire drive connected to another server. The bakcup runs and seems to be complete, but ends with an error. When I check the SQL Server log the error is:

BackupDiskFile::RequestDurableMedia: failure on backup device '\\cherry\dumps\mole\molert_full.BAK'. Operating system error 87(The parameter is incorrect.).

I have googled the error and have not found anything that is of any help. Most of the hits are just MS error code listings. Does anyone know anything about this Operating System Error?

I am successfully using htis backup strategy at another location.

Thanks,





Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming
At best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at work

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
rstone
rstone
SSC-Addicted
SSC-Addicted (405 reputation)SSC-Addicted (405 reputation)SSC-Addicted (405 reputation)SSC-Addicted (405 reputation)SSC-Addicted (405 reputation)SSC-Addicted (405 reputation)SSC-Addicted (405 reputation)SSC-Addicted (405 reputation)

Group: General Forum Members
Points: 405 Visits: 824
Did you check the EventLogs on each system? Maybe there is a network hardware or configuration problem.

Randy
Helpdesk: "Perhaps I'm not the only one that does not know what you are doing." ;-)
Jack Corbett
  Jack Corbett
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: General Forum Members
Points: 11014 Visits: 14858

There are no errors in the Event Logs other than the failure due to OS Error 87. IT is interesting that in the other location where we are using this solution we are experiencing the same problem now after applying the latest Windows Updates. Since it happened at the end of our day we put a short-term fix in and will be working on it tomorrow. We will probably roll back the updates applied today one at a time and see which one may have caused the problem. I will post what we find out.

If anyone else has seen this problem please let me know what you did to correct it.





Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming
At best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at work

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Jonathon Coleman
Jonathon Coleman
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 1
You said that the backup completed but is the file valid? Can you successfully perform restores off of this backup file?
Jack Corbett
  Jack Corbett
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: General Forum Members
Points: 11014 Visits: 14858
I have not verified the backup. Currently we are using another solution to get backups completed successfully.



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming
At best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at work

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
tguthier
tguthier
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 5

I've the same problem. Backing up around 20 DB's the same way. Only master or msdb fails with that error message all others with success. I verified the backup, everthing is all right.





Jack Corbett
  Jack Corbett
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: General Forum Members
Points: 11014 Visits: 14858
This may be related to the latest McAffee Upgrade we did from 7.1 to 8.0i.



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming
At best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at work

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Jeff Orwick
Jeff Orwick
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 78
I've received the same error one time, for a handful of databases, performing native SQL Server Transaction Log Backups, followed by error 53 a second later. Then backup operations to the same NAS location began working again.

Transaction Logs backup every 15 minutes. Each job is the standard MS SQL Agent Log Shipping Backup, created by the wizard.

One database on the server failed with the same error about 9 hours later.

!!!Comment!!! denotes information stripped out for privacy.


...Completed successfully...
11/29/2011 02:30:07,Backup,Unknown,Log was backed up. Database: !!!Database1!!!<c/> creation date(time): 2011/07/30(23:27:04)<c/> first LSN: 991365:14418:1<c/> last LSN: 991365:14418:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'\\den-sqldump\prod\den-sql3\Tran\!!!Database1!!!_20111129093007.trn'}). This is an informational message only. No user action is required.
11/29/2011 02:30:07,Backup,Unknown,Log was backed up. Database: !!!Database6!!!<c/> creation date(time): 2011/07/31(00:02:54)<c/> first LSN: 90691:15669:1<c/> last LSN: 90691:15669:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'\\den-sqldump\prod\den-sql3\Tran\!!!Database6!!!_20111129093007.trn'}). This is an informational message only. No user action is required.


...Failed Transaction Log Backups...
11/29/2011 02:29:07,Backup,Unknown,BACKUP failed to complete the command BACKUP LOG !!!Database2!!!. Check the backup application log for detailed messages.
11/29/2011 02:29:07,Backup,Unknown,Error: 3041<c/> Severity: 16<c/> State: 1.
11/29/2011 02:29:07,Backup,Unknown,BACKUP failed to complete the command BACKUP LOG !!!Database3!!!. Check the backup application log for detailed messages.
11/29/2011 02:29:07,Backup,Unknown,Error: 3041<c/> Severity: 16<c/> State: 1.
11/29/2011 02:29:07,spid75,Unknown,BackupDiskFile::CreateMedia: Backup device '\\den-sqldump\prod\den-sql3\Tran\!!!Database2!!!_20111129092907.trn' failed to create. Operating system error 53(The network path was not found.).
11/29/2011 02:29:07,spid75,Unknown,Error: 18204<c/> Severity: 16<c/> State: 1.
11/29/2011 02:29:07,spid74,Unknown,BackupDiskFile::CreateMedia: Backup device '\\den-sqldump\prod\den-sql3\Tran\!!!Database3!!!_20111129092907.trn' failed to create. Operating system error 53(The network path was not found.).
11/29/2011 02:29:07,spid74,Unknown,Error: 18204<c/> Severity: 16<c/> State: 1.
11/29/2011 02:28:08,Backup,Unknown,BACKUP failed to complete the command BACKUP LOG !!!Database4!!!. Check the backup application log for detailed messages.
11/29/2011 02:28:08,Backup,Unknown,Error: 3041<c/> Severity: 16<c/> State: 1.
11/29/2011 02:28:08,spid71,Unknown,BackupDiskFile::CreateMedia: Backup device '\\den-sqldump\prod\den-sql3\Tran\!!!Database4!!!_20111129092808.trn' failed to create. Operating system error 87(The parameter is incorrect.).
11/29/2011 02:28:08,spid71,Unknown,Error: 18204<c/> Severity: 16<c/> State: 1.
11/29/2011 02:28:07,Backup,Unknown,BACKUP failed to complete the command BACKUP LOG !!!Database5!!!. Check the backup application log for detailed messages.
11/29/2011 02:28:07,Backup,Unknown,Error: 3041<c/> Severity: 16<c/> State: 1.
11/29/2011 02:28:07,spid65,Unknown,BackupDiskFile::CreateMedia: Backup device '\\den-sqldump\prod\den-sql3\Tran\!!!Database5!!!_20111129092807.trn' failed to create. Operating system error 87(The parameter is incorrect.).
11/29/2011 02:28:07,spid65,Unknown,Error: 18204<c/> Severity: 16<c/> State: 1.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search