Post reply

BackupDiskFile::CreateMedia: Backup device' failed to create. Operating system error 5(Access is denied.).

  • September 11, 2015 at 8:03 am

    #320525

    Dear all,

    When I try and create a transactional log shipping I get the following error; I have done the following

    - Made sure the sql server service account has access to the network share folder and also where the cop files are going to

    - make sure the locations where the backup and restore file are located can be connected t

    Would someone let me know if I'm missing something or what I'm doing wrong please?

    Message

    BackupDiskFile::CreateMedia: Backup device '\etworklocationname\transactionlogfile.trn' failed to create. Operating system error 5(Access is denied.).

    Thank you!

  • September 11, 2015 at 8:28 am

    #1825999

    This is a permissions issue on the folder.

    Are you using a domain account for your service account? This account needs to have full control on this folder.

    Run this, if you get an "access is denied" error, it's definitely permissions.

    EXEC sp_configure 'show advanced options',1

    RECONFIGURE

    go

    EXEC sp_configure 'xp_cmdshell',1

    RECONFIGURE

    Go

    DECLARE @cmd varchar(200) = 'DIR \\Your share name and path\*.* /b'

    EXEC xp_cmdshell @cmd

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

  • September 11, 2015 at 9:19 am

    #1826035

    Thank you for your reply!

    I get return values when I execute the script and I get a return value without any access issues.

  • September 14, 2015 at 4:43 am

    #1826312

    Hi,

    Maybe you have read permissions on the share folder but not write access. Use the same method above but creating a new file. Like echo hello > \\share\file.txt

    Regards

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

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