Post reply

How can my job run successfully

  • August 12, 2011 at 12:51 am

    #246187

    Hi,

    I have the all sql server services running with NTAuthority\Network Service account and I am configuring the "Backup Database Task" in maintenance plan and backup file location is on file server at remote location and that backup folder is shared.

    Now my backup job is failing with error "Cannot open backup device".How to add NTAuthority\Network Service account on remote server shared backup folder or how can my job run successfully.

    NTAuthority\Network Service is a not a domain account.

    Thanks

  • August 12, 2011 at 1:48 am

    #1367746

    Have you checked if you can open the shared folder using \\servername\shared_folder from your server?

    Ryan
    //All our dreams can come true, if we have the courage to pursue them//

  • August 12, 2011 at 1:54 am

    #1367748

    Thanks Sumanta,

    Yes I can.

    Can anybody tell in all the sql server services which one is the specific service dedicated for backup command?

    ALL sql services are running as Network service account.

    Thanks

  • August 12, 2011 at 2:00 am

    #1367751

    I would strongly advise running your SQL Server services under a domain account. I don't know whether it's possible to grant access to Network Service on a remote computer, but even if it is, it means that you are granting access to anything that runs under that account, anywhere. That's quite a security risk.

    John

  • August 12, 2011 at 2:22 am

    #1367760

    Hi,

    Thanks, is there any msdn link on sql server and network service account.

    Is there any other way to run the backup successfully.

    Thanks

  • August 12, 2011 at 2:29 am

    #1367764

    forsqlserver (8/12/2011)

    Thanks, is there any msdn link on sql server and network service account.

    I'm sure the search engine you use is as good as the one that I do.

    Is there any other way to run the backup successfully.

    Well, you could back up to a location on the SQL Server, and then use another process to copy the backup file to the remote location.

    John

  • August 12, 2011 at 2:34 am

    #1367765

    You should always backup to the local server in the first instance. Once the backup is succesfull this should be copied to another network location where in an ideal world it is verified and backed up to tape.

    There are many processes you can use to copy the backup files if your SQL Server accounts do not have permissions. You could create a scheduled task and use a process like robocopy to copy the files to another location on the network.

    Thanks

    Chris

    ------------------------
    I am the master of my fate:
    I am the captain of my soul.
    ------------------------
    Blog: http://sqlserver365.blogspot.co.uk/
    Twitter: @ckwmcgowan
    ------------------------

Viewing 7 posts - 1 through 6 (of 6 total)

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