SQl SERVER Error Cannot open backup device Operating error 6

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!
LVL 3
DDBAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Cameron YoungConnect With a Mentor IT ManagerCommented:
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
 
Rich WeisslerProfessional Troublemaker^h^h^h^h^hshooterCommented:
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
 
DDBAuthor Commented:
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
All Courses

From novice to tech pro — start learning today.