Sample Header Ad - 728x90

How to fix an odd LSBackup job error in Log Shipping?

3 votes
1 answer
2603 views
Configuration: - **LSPrimary01** - Log Shipping Primary - **LSSecondary01** - Log Shipping Secondary - **OddServer03** - This server is not part of the LS configuration, the odd man out - *Sean\LSServiceAccount* - The domain user service account for log shipping on all servers A colleague of mine and I were configuring Log Shipping in a test environment. We took a full COPY_ONLY backup of a database on **LSPrimary01**, a log backup, copied to **LSSecondary01** and restored the backup and log WITH NORECOVERY. Then used the GUI on **LSPrimary01** to configure Log Shipping. We already configured file sharing and proper permissions for *Sean\LSServiceAccount*. The following error was the result: - START OF TRANSACTION LOG BACKUP - Error: Could not retrieve backup settings for primary ID'cb1564b4-4ffd-a42d'.(Microsoft.SqlServer.Management.LogShipping) - Error: Failed to connect to server **OddServer03**.(Microsoft.SqlServer.ConnectionInfo) - Error: Login failed for user '*Sean\LSServiceAccount*'.(Net SqlClient Data Provider) - END OF TRANSACTION LOG BACKUP I ran the following query to verify my Log Shipping configuration: SELECT [primary_database] ,[backup_directory] ,[backup_share] ,[backup_retention_period] ,[monitor_server] ,[user_specified_monitor] ,[monitor_server_security_mode] ,[last_backup_file] ,[last_backup_date] FROM [msdb].[dbo].[log_shipping_primary_databases] Everything in the result set was correct, save *monitor_server*, it had the value of **OddServer03**! As many of you know, when configuring Log Shipping through the GUI, it is damn near impossible to "accidentally" configure this option. We never intended having a monitor server in the mix. We use *Quest Spotlight* to monitor the aforementioned servers which will yield alerts when jobs fail or when log shipping gets behind. One other perplexing matter, the job that is getting created is LSAlert_OddServer03 instead of LSAlert_LSPrimary01. Why is the service account trying to authenticate to a server that isn't part of the configuration?
Asked by AKDiscer (1395 rep)
Mar 17, 2017, 02:50 PM
Last activity: Feb 8, 2025, 06:06 AM