SQL2005 - Backup database to shared network location using maintenance plan

Posted on 2011-10-20
Last Modified: 2012-05-12
I'm trying to backup to a shared network location using the backup task within maintenance plans. The instance is connected to a local account and I'm able to navigate and write to the directory on the SQL Server. When I execute the plan I receive a successful result but when navigating to the directory it's blank. The SQL version is SP3.

Any help is very much appreciated.

Question by:klwn
    LVL 11

    Expert Comment

    by:Sanjay Santoki

    If you are taking backup service account should have write permission on the network resources.

    Sanjay Santoki

    Author Comment

    Hi - Just to clarify we are using Windows authentication to launch Management Studio using a local windows account. We have already proven that write permissions are active as we have been able to create a new file within the folder for the shared resource.
    Please see screen shot below:

    LVL 11

    Accepted Solution


    Thanks for providing the details. However, as per me it is the authentication to open SQL management studio not for the backup job. Normally backup job uses service account authentication.

    Sanjay Santoki

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
    In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
    This video discusses moving either the default database or any database to a new volume.
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    25 Experts available now in Live!

    Get 1:1 Help Now