![]() ![]() ![]() 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. 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 created a share on the secondary as \secondary\SqlLogShipData, gave full control to the domain account, and added two sub-directories: Backup and Destination. SQL Server and the SQL Server Agent are running on the primary and secondary under a domain account. Where is the 'backup application log'? 2. Check the backup application log for detailed messages 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:īACKUP Failed to complete the command BACKUP LOG MyDb. I am trying to configure log shipping from a cluster of two Windows Server 2008 R2 圆4 machines running SQL Server 2008 R2 to a single machine running the same OS and DB. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |