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

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 '\\networklocationname\transactionlogfile.trn' failed to create. Operating system error 5(Access is denied.).

Thank you!


  • Edited by ti2 16 hours 58 minutes ago
September 11th, 2015 10:08am
Try running a simple backup and restore from that network location using the same service account.
Free Windows Admin Tool Kit Click here and download it now
September 11th, 2015 1:32pm
Try running SSMS in Admin mode.
September 11th, 2015 2:45pm
Thank you for your reply! I had to add the sqlserver service account to the network share and it worked.
Free Windows Admin Tool Kit Click here and download it now
September 12th, 2015 2:49am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics