January 21, 2010 at 9:45 am
Hi, I am backing up 2008 primary to 2008 secondary servers. I have setup a shared drive on the secondary and given it full permissions for all users (just while I sort this out)
However the primary server Windows/Application Event log gives me this error everytime the log shipping job runs.
BackupDiskFile::CreateMedia: Backup device '\\xx.xx.xx.xx\_tranlogs\DB3_20100121163001.trn' failed to create. Operating system error 5(failed to retrieve text for this error. Reason: 15105).
I have searched on this and it seems as though it is a permissions issue, but if the shared directory has full permissions for 'everyone' where am I going wrong?
Many thanks for any pointers on this matter.
ew
January 21, 2010 at 10:49 am
What are the NTFS permissions on the folder? For sharing there must be the share permission and the underlying NTFS file system permissions
The SQL service account must have read and write permission at minimum. If you're running as local system, that account won't have any permissions elsewhere else.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 17, 2010 at 9:55 am
Hi,
Sorry for the delay in checking my post, I had almost given up!
The 'share' directory _logs has R+W permissions for the local SQL server agent, the specially created account for log shipping and my login, which is used by the primary server to network in batch file mode to the secondary server. I also have Anonymous Logon with R+W permissions.
SQL Server Agent on primary and secondary are both configured to run under the domain account for log shipping, not local or system and this account has full permissions as sysadmin for both servers.
At the scheduled time I attempt to run the process from the primary server I have a successful ANONYMOUS login appear in the logs for the secondary server, and a login from the account used to set up the transaction log shipping connection to the secondary server.
The Primary server is behind a firewall run by the hosting company that surrounds all their servers, and there is no firewall on the individual server. I was concerned that there might be a firewall blockage somewhere outside of my control.
I am quite confused about the lack of information on this as I would have thought this would have been almost a 'out of the box' solution run by thousands of users.
Thanks for the reply though!
ew
March 29, 2010 at 3:55 pm
Hi, as gilamonster says, its a permissions issue. Make sure there are R+W permissions on the restore directory too, not just the location where the logs are copied to, IE - where the database files (mdf, ldf) on the secondary server are restored to.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply