Solved

SQl SERVER Error Cannot open backup device  Operating error 6

Posted on 2012-04-09
3
352 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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:
Cameron Young 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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

This article is an update and follow-up of my previous article:   Storage 101: common concepts in the IT enterprise storage This time, I expand on more frequently used storage concepts.
Create your own, high-performance VM backup appliance by installing NAKIVO Backup & Replication directly onto a Synology NAS!
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

636 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