SQL SERVER – FIX – ERROR : Msg 3201, Level 16 Cannot open backup device.Operating system error 3 (The system cannot find the path specified.)

I had very interesting and frustrating experience. Recently I was attempting to backup one of my database and I end up on following error.

Msg 3201, Level 16, State 1, Line 1
Cannot open backup device ‘D:\Backup\SQLAuthority.bak’. Operating system error 3(The system cannot find the path specified.).
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.

Solution:

Go to your drive and create the missing folder. In my case I went to Drive D and created Backup Folder there.

Additional Story:

SQL SERVER - FIX - ERROR : Msg 3201, Level 16 Cannot open backup device.Operating system error 3 (The system cannot find the path specified.) backup-database

If you read the first line of the blog post you will read there that I mentioned that I had frustrating experience. It was not frustrating that I do not know the solution – it was totally different reason. When I encountered the above error I quickly went and created the folder in my machine. Once I created the folder, I still keep on getting the error. After a while I realize what I was doing. I was creating the folder in the machine where I had installed SQL Server Management Studio. To resolve this error one has to create the folder in the machine where SQL Server is installed. Once I created the folder to the location where I was attempting to take backup the issue was resolved.

How many of you have been in the same situation as me as mentioned in additional story?

Reference : Pinal Dave (https://blog.sqlauthority.com)

, ,
Previous Post
SQL SERVER – 2012 Auditing Enhancement – On Audit Log Failure Options – Maximum Rollover Files
Next Post
SQL SERVER – AdventureWorks for SQL Server 2012 RC0 – Samples Database for SQL Server 2012 RC0

Related Posts

27 Comments. Leave new

  • In our environment we are getting this error regularly…

    -Jana

    Reply
  • Not exactly the same scenario but I have faced this error when I tried to bcp out a table to a file. It was throwing bcp error again and again. Had struggled for 2 hours and then finally found out the mistake that I was just creating the folder in the client side rather than server side. Then finally put the same command in the command prompt and found out that it was searching for a folder in server side :) and it worked

    Reply
  • I have done something similar in the past with a SQL Agent job step trying to point to an SSIS file system package… it took me a minute to realize that the error about an invalid XML file format was because SSMS was looking for the file on my local machine and not on the server where SQL and the dtsx package was located.

    Reply
  • Nakul Vachhrajani
    December 17, 2011 11:22 am

    I would say that almost everyone who has ever restored a database from a remote Management Studio instance has encountered this error.
    While we now have this in our blood, I see a lot of newcomers walking down to my desk saying they can’t restore a DB – most often it’s either that they do not have a folder or that they forget that the SSMS UI shows them the remote server’s disks.

    Reply
  • Hi pinal,
    Must say its a very inspirational site for SQL SERVER DBA’s.
    Coming to my issue,getting a similar error code,while taking the backup to the network drive.

    Msg 3201, Level 16, State 1, Line 1
    Cannot open backup device ‘\\ IP address \abc’. Operating system error 1326(Logon failure: unknown user name or bad password.).
    Msg 3013, Level 16, State 1, Line 1
    BACKUP DATABASE is terminating abnormally.

    Below are the few solutions applied for the error:
    1. Folder has the full rights.(administartor login)
    2. Using the same Login as SQL SERVER AGENT.
    3.Mapped the network drive.

    Still struggling for the solution.
    Waiting for your reply.

    Reply
  • I have had these kind of issues before especially accessing drives on local folder vs folder on the server. Especially when it comes to these kind of issues i guess it would be best to work it out on the server rather than the client.

    Reply
  • If we found this type of error then, we need to one step, we can run from required path from cmdshell.

    xp_cmdshell ‘dir D:\Backup\’

    So we come to is this folder is there or not.

    Reply
  • I had very interesting and frustrating experience. Recently I was attempting to backup one of my database and I end up on following error.

    Msg 3201, Level 16, State 1, Line 1
    Cannot open backup device ‘D:becommon.bak’. Operating system error 2(The system cannot find the path specified.).
    Msg 3013, Level 16, State 1, Line 1
    BACKUP DATABASE is terminating abnormally.

    please i need help sir, i hope this issues ….

    Reply
  • I just can say, Thank you so much!

    Reply
  • I also get same error but i m not using any folder, i m giving just D:\ SQLAuthority.bak in plce of D:\Backup\SQLAuthority.bak then if any one have this solution Plzz give me ,,,

    Thanks in advance

    Reply
  • Venkatesh Malepati
    December 18, 2013 2:14 am

    Try without INIT. The INIT might be the problem. Anyway, it is bad practice to overwrite back up files. Hope that helps

    Reply
  • I was facing same error in one of my database. I am taking backup on remote location. Out of 23 database only one database backup is giving me same error. I found out that there is space in the database name at the end. I remove that space and now backup job is running without error.

    Reply
  • Hi Pinal and all,

    I would like to add comment on this OS error3 topic. I experienced this issue recently. It was driving me nut and unable to sleep as things were set up perfectly, all permission applied but still SQL agent job which was creating backup was failing. The SQL agent job was not able to create full or transaction backups for one database. All other databases were backing up as expected.
    Finally, I found solution. The database name had problem. Name of the database contained space after name like (‘SQL ‘ instead ‘SQL’). Also, I was able to creating backups for this databases through script but not scheduled maintenance job. Now I will schedule to rename this database and include this database into regular backups schedule.

    Reply
  • I was having this error because name of the databases was containing space after name like ‘SQL ‘ instead of ‘SQL’. Now will schedule to rename this database name and include this database to regular maintenance plan.

    Reply
  • I ran into this situation today. Thanks for the blog post – saved me a lot of trouble!

    Reply
  • C:\Program Files\Microsoft SQL Server\110\Tools\Binn
    I provide above path to store remote server backup . It shows backup completed but not getting backup on that location.

    Reply
  • I have a situation where i have to backup on to network shared drive (in my case this is the network shared folder : ‘ \\ \\sdhqem***** \SQL****up’ ) and this drive is password protected (it has a login and password to that drive ). How do i specify the destination while full backup to this network drive(of different server) which has a login and password?

    Thanks in advance

    Reply
    • When you connect via Windows Explorer, do you have to provide the password? You can map the shared location as drive with in SQL Server using net use command. In net use command you can provide username and password to connect. Have you read my recent blog on the same topic
      https://blog.sqlauthority.com/2015/03/18/sql-server-backup-on-mapped-drive-failing-with-error-msg-3201-level-16-state-1-operating-system-error-3the-system-cannot-find-the-path-specified/

      Reply
      • Thank you Pinal. Yes, i could login using the credentials by referring to your post on Backup on mapped drive failing with error – Msg 3201, Level 16, State 1 – Operating system error 3(The system cannot find the path specified.)

      • What is the command you are running? Are you sure path is correct?

      • I used
        EXEC sp_configure ‘advanced’, 1
        RECONFIGURE WITH override
        GO
        EXEC sp_configure ‘xp_cmdshell’, 1
        RECONFIGURE WITH override
        GO
        and then I executed the below statement using the credentials for the network shared folder:
        EXEC xp_cmdshell ‘net use Z: “\servernameshareddrivename” /user:mydomainmyusername mypassword

        I actually got the idea from your blog and did a little more search for entering username and password.
        Found the below link to enter the credentials:

        It worked out and now my backups are directly being copied on the network drive !

        Hope this helps someone in the near future :)

        Thanks Pinal for such an amazing blog !

        Regards,
        Tanmayee

Leave a Reply

Menu