locked
Trouble backing up to a network share RRS feed

  • Question

  • I am having trouble trying to get MSSQL 2005 to backup to a network share.

    Cannot open backup device '\\srvr106\logshipping\mydb.bak'.
    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.

    Here is the setup:
    + MSSQL 2005 Enerprise Edition on Windows Server 2003 R2 64-bit;

    + \\srvr106\logshipping - share is located on windows 2007 server Enterprise service pack 2; 64-bit

    + MSSQL is running under windows account that is in Admin group on this machine, (the same Windows account exists on the destination srvr106 server in Admin Group).

    + both srvr106 & srvr104 servers are in the same workgroup (no domain only workgroup).
    + destination server srvr106 allows everyone full control to share.

    ----
    Interesingly, the backup works fine for another share on another Windows Server 2003 R2 server, called srvr104, but not for srvr106, which has Win 2007 as described above.
    Is that a problem?

    thank you!


    Daniel
    Saturday, November 27, 2010 6:34 AM

Answers

  • Double check that the SQL Server service account can write to that share folder, it sounds like a permissions problem. Have a look at the following blog article for an example...

    http://www.revindex.com/?tabid=65&EntryID=18

     

    Thanks


    /Neil Moorthy - Senior SQL Server DBA/Developer (MCITP (2005), MCAD, OCA 11g) Please click the Mark as Answer button if a post solves your problem
    • Marked as answer by Danik1994 Monday, November 29, 2010 5:19 AM
    Saturday, November 27, 2010 9:24 AM

All replies

  • Double check that the SQL Server service account can write to that share folder, it sounds like a permissions problem. Have a look at the following blog article for an example...

    http://www.revindex.com/?tabid=65&EntryID=18

     

    Thanks


    /Neil Moorthy - Senior SQL Server DBA/Developer (MCITP (2005), MCAD, OCA 11g) Please click the Mark as Answer button if a post solves your problem
    • Marked as answer by Danik1994 Monday, November 29, 2010 5:19 AM
    Saturday, November 27, 2010 9:24 AM
  • Instead of directly writing the backup to the network share, I would backup the database to local disk and then use a batch job to copy it to the network share using ROBOCOPY.


    Pradeep Adiga
    Blog: sqldbadiaries.com

    Recent posts on my blog
    Saturday, November 27, 2010 10:20 AM
  • Hi Daniel,

    To check whether the SQL Server service account has appropriate permission on the share folder or not, please log on to SQL Server box using SQL Server server account, make usre you can access \\srvr106\logshipping share folder and on which you have write permission. For more information please refer to a previous forum thread Windows 7 can't access Share in a workgroup (http://social.technet.microsoft.com/Forums/en-US/w7itpronetworking/thread/68ffbe2a-09a7-4e29-859c-ca1aaf75dcd1)

    Since you are in a workgroup but not a domain environment, you may try to back up databases to local box and then copy backup files to share folder.

    For more information you can refer to Backup SQL Server Databases to a network share drive (http://blogs.msdn.com/b/varund/archive/2009/06/04/backup-sql-server-database-to-a-share-drive-on-another-server.aspx).

    Thanks,
    Chunsong


    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Monday, November 29, 2010 3:00 AM
  • You are right. This is a permissions problem.

    The passwords were different on the source and destination servers for the same account (the MSSQL is running under ).

    I guess, it matters if you have a workgroup...

    thank you all!

     

     


    Daniel
    Monday, November 29, 2010 5:26 AM