Post reply

Manually run a backup to a network sharepoint?

  • July 31, 2007 at 9:02 am

    #118018

    Hi

    I am simply trying to run a backup to a network sharepoint.

    I have mapped the drive, Z:\Bob, but I am not allowed to browse to it when I am looking for a location.

    I attempt to force it with \\Bob\Backup.bak

    But I get an access denied error.

    The SQL accounts run under the local accounts they were set up with.

    Any help would be great, thanks.

     

  • July 31, 2007 at 9:07 am

    #723621

    You can't backup to the network from within SQL if you are running SQL Agent under local account, has to be a domain accont.

  • July 31, 2007 at 9:18 am

    #723628

    So if I change the account that the SQLAgent runs under will that effect anythign else?

    Also, I did try to change the account to a working domain account.

    The service would then not start up.

    Any ideas?

     

  • July 31, 2007 at 1:14 pm

    #723700

    You need to have an account that has the appropriate security on the server itself as well.  The answer to appropriate is "it depends" but this is fairly well documented in Books Online.

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

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