Post reply

Backups failing with ACCESS DENIED

  • September 17, 2014 at 7:34 am

    #296312

    Hello,

    I have a bunch of servers (2000, 2005,2008,2012) that run bakups to network filer.

    All servers (and SQL Agents) run under the same domain account.

    This account has full permissions to filer.

    Some servers run backups fine and some servers get this:

    BACKUP DATABASE [model] TO DISK = N'\\xxxxx.com..." failed with the following error: "Cannot open backup device '\\xxxxxxx.com\dfs$\Archived\Sql\Backups\Full\model_backup_2014_09_17_000007_6936557.bak'. Operating system error 5(Access is denied).

    I can not figure what is different about "bad" server and problem is not version specific. It is accross all versions.

    Any ideas?

    Thanks.

  • September 17, 2014 at 9:36 am

    #1746118

    Andrei-176105 (9/17/2014)

    Hello,

    I have a bunch of servers (2000, 2005,2008,2012) that run bakups to network filer.

    All servers (and SQL Agents) run under the same domain account.

    This account has full permissions to filer.

    Some servers run backups fine and some servers get this:

    BACKUP DATABASE [model] TO DISK = N'\\xxxxx.com..." failed with the following error: "Cannot open backup device '\\xxxxxxx.com\dfs$\Archived\Sql\Backups\Full\model_backup_2014_09_17_000007_6936557.bak'. Operating system error 5(Access is denied).

    I can not figure what is different about "bad" server and problem is not version specific. It is accross all versions.

    Any ideas?

    Thanks.

    Are you sure that the backup devices exist on the network filer?

    If they do, have you checked to see if they are expired? SQL Server has options to expire backup devices.

    Also, if something else has the device open (basically if the network filer has retained some sort of open connection on the file), you won't be able to access it.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • September 17, 2014 at 9:41 am

    #1746122

    FYI

    I was able to resolve this problem by adding backup servers to permissions on the filer and also giving access to the filer root just for "trouble" servers.

    It is all working now.

  • September 17, 2014 at 9:44 am

    #1746124

    Excellent.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

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