Solved

SQl SERVER Error Cannot open backup device  Operating error 6

Posted on 2012-04-09
3
350 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 30

Expert Comment

by:Rich Weissler
ID: 37824899
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
ID: 37825664
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
ID: 37829445
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

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Why run Active Fulls in Backups 19 157
Netapp and Vcenter report 9 102
How to format tape Cartridge to LTFS 6 111
My reclamation process on TSM is failing. 2 120
By default, Carbonite Server Backup manages your encryption key for you using Advanced Encryption Standard (AES) 128-bit encryption. If you choose to manage your private encryption key, your backups will be encrypted using AES 256-bit encryption.
A Bare Metal Image backup allows for the restore of an entire system to a similar or dissimilar hardware. They are highly useful for migrations and disaster recovery. Bare Metal Image backups support Full and Incremental backups. Differential backup…
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will walk an individual through the process of configuring basic necessities in order to use the 2010 version of Data Protection Manager. These include storage, agents, and protection jobs. Launch Data Protection Manager from the deskt…

730 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