Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error on Backup to Netweork Location Expand / Collapse
Author
Message
Posted Tuesday, December 28, 2004 1:15 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:07 AM
Points: 11,157, Visits: 12,899

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

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
Post #152729
Posted Wednesday, December 29, 2004 9:18 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 10:21 AM
Points: 361, Visits: 564
Did you check the EventLogs on each system?  Maybe there is a network hardware or configuration problem. 

Randy
"Perhaps I'm not the only one that does not know what you are doing."
Post #152865
Posted Wednesday, December 29, 2004 3:05 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:07 AM
Points: 11,157, Visits: 12,899

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

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
Post #152932
Posted Wednesday, December 29, 2004 3:43 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 29, 2004 3:41 PM
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?
Post #152938
Posted Thursday, December 30, 2004 10:10 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:07 AM
Points: 11,157, Visits: 12,899
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

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
Post #153027
Posted Tuesday, January 4, 2005 12:51 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, January 30, 2009 2:55 AM
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.




Post #153398
Posted Tuesday, January 25, 2005 10:01 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:07 AM
Points: 11,157, Visits: 12,899
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

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
Post #157553
Posted Tuesday, November 29, 2011 9:06 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 7, 2014 4:10 PM
Points: 10, Visits: 50
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.
Post #1213653
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse