Solved

SQl SERVER Error Cannot open backup device  Operating error 6

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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

How to update Firmware and Bios in Dell Equalogic PS6000 Arrays and Hard Disks firmware update.
Microservice architecture adoption brings many advantages, but can add intricacy. Selecting the right orchestration tool is most important for business specific needs.
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
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…

911 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

20 Experts available now in Live!

Get 1:1 Help Now