Error on Backup to Netweork Location

  • 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
    Consultant - Straight Path Solutions
    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

  • Did you check the EventLogs on each system?  Maybe there is a network hardware or configuration problem. 

    Randy
    Helpdesk: Perhaps Im not the only one that does not know what you are doing. 😉

  • 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
    Consultant - Straight Path Solutions
    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

  • You said that the backup completed but is the file valid?  Can you successfully perform restores off of this backup file?

  • I have not verified the backup.  Currently we are using another solution to get backups completed successfully. 

    Jack Corbett
    Consultant - Straight Path Solutions
    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

  • 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.

  • This may be related to the latest McAffee Upgrade we did from 7.1 to 8.0i.

    Jack Corbett
    Consultant - Straight Path Solutions
    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

  • 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.

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply