Map Network drive not visibile for backup?

  • Hi,

    I have mapped network drive for backup purpose. It is showing server level. But it is not visible in Management plan at chose backup drive location.. what could be issues?

    SQL Agnet account - running under Network sercive account.

    Error Messages:

    Operating system error 3(The system cannot find the path specified.).

    BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

    Thanks

    ananda

  • For database backup taking on network dirve, Is it really require to enable XP_CMDSHELL feature in instance side? there may be security issues

  • Agreed on xp_cmdshell. The very simple procedure is outlined here.

    http://blogs.msdn.com/b/varund/archive/2009/06/04/backup-sql-server-database-to-a-share-drive-on-another-server.aspx

  • ananda.murugesan (10/11/2013)


    Hi,

    I have mapped network drive for backup purpose. It is showing server level. But it is not visible in Management plan at chose backup drive location.. what could be issues?

    SQL Agnet account - running under Network sercive account.

    Error Messages:

    Operating system error 3(The system cannot find the path specified.).

    BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

    Thanks

    ananda

    You don't need to see it in the GUI to use it. Just use the UNC for the backup path and it'll work just fine.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Hi Anada,

    Does your service account has permission to the network share?

    You should be able to navigate to the folder when you are logged into the server and confirm by checking the folder permissions/properties?

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply