I am trying to configure log shipping from a cluster of two Windows Server 2008 R2 x64 machines running SQL Server 2008 R2 to a single machine running the same OS and DB. Setup appears to go okay (no errors) but at the scheduled time I get the following pair of errors in the primary machine's SQL Server event log:
BACKUP Failed to complete the command BACKUP LOG MyDb. Check the backup application log for detailed messages
Error: 3041, Severity 16, State 1
Questions: 1. Where is the 'backup application log'? 2. How do I find out what error 3041 is?
SQL Server and the SQL Server Agent are running on the primary and secondary under a domain account. I created a share on the secondary as \secondary\SqlLogShipData, gave full control to the domain account, and added two sub-directories: Backup and Destination.
When I configured log shipping I gave \secondary/SqlLogShipData\Backup as the network path to the backup folder, and for the secondary I give \secondary\SqlLogShipData\Destination as the destination folder for copied files.
I put the backup folder on the secondary because the primary is a cluster and I want the log shipping to work when either node is active. I also tried specifying a directory that is local to the primary but this made no difference.
There are no relevant errors in the secondary's sql event log.
My guess is that this is a permissions issue, but I'm not sure why. I'd appreciate any help that you may be able to give me.