Solved

SQl SERVER Error Cannot open backup device  Operating error 6

Posted on 2012-04-09
3
345 Views
Last Modified: 2013-01-24
Trying to restore database from source using UNC. Got error:

Cannot open backup device '\\xxx\C$\DBBackups\xxx.bak'. Operating system error 6(The handle is invalid.).

Thank you!
0
Comment
Question by:DDB
3 Comments
 
LVL 29

Expert Comment

by:Rich Weissler
Comment Utility
First, confirm that there aren't any typos in the UNC,
then, make certain you don't have any network issues.
The file itself may also be corrupt... if it isn't prohibitively large, confirm that you can copy it.  (If it isn't excessive, I'd be tempted to try copying to a local drive on the SQL server (1) to confirm that file itself isn't corrupt from the operating system point of view), and (2) to see if you can perform the restore from a local volume.)
0
 
LVL 4

Accepted Solution

by:
hazzic earned 500 total points
Comment Utility
I'd suggest moving the file local to the database server if possible, this should eliminate any UNC related or network related possibilities and tell you if the file is working.

If it is, make sure you can see the administrative share (C$) from another machine.
0
 
LVL 3

Author Comment

by:DDB
Comment Utility
I tepmted to do so but backup file is huge to move it. The source server was rebooted at night and job ran successfully.
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Are you looking to recover an email message or a contact you just deleted mistakenly? Or you are searching for a contact that you erased from your MS Outlook ‘Contacts’ folder and now realized that it was important.
The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now