You must Sign In to post a response.
  • Category: SQL Server

    How to Backup SQL Databases to a Network Drive/Share

    Hi All,

    How can I take a backup SQL databases to a network drive or share. I tried in the following ways, but ending with errors:

    I gave File Name as: \\SqlServer\DatabaseBackup\Test.bak



    But in the both way, I am getting following error:

    cannot open backup device '\\SqlServer\DatabaseBackup\Test.bak'. Operating system error 1326

    Thanks in advance.
  • #761673
    Hello Ram Prasad,

    Refer the below link :

    Hope this will help you to solve your problem.

    Nirav Lalan
    DNS Gold Member
    "Failure is the path of least persistence"

  • #761717
    If you are using a unc (shared path) then it may give access denied or path not found exception.
    Make sure the file is visible from the machine with sql server. If it is but you still get the error, it can be only one thing - the login that the SQL Server service is running under does not have access to the network location. In my case, I went to Control Panel -> Administrative Tools -> Services (on the server). I found the SQL Server service and checked it's properties and discovered that it was using the local administrator account (.\Administrator) which obviously doesn't have access to the rest of the domain. I changed this to a domain user, restarted the service, and voila, unc paths work fine now

    Editor, DotNetSpider MVM
    Microsoft MVP 2014 [ASP.NET/IIS]

Sign In to post your comments