none
Log Shipping Backup failed RRS feed

  • Question

  • Hi ,

    I have configured log shipping on server 2008. My Steps: Change DB to Full recovery mode.
    Took a full backup on primary.
    Restored with in secondary.
    Again ran a log backup and restored on secondary with no recovery.

    At this time I forgot to disable log backup maint- Job)
    Configured log shipping.
    system maint- Job backed up a log file.
    Again Restored the Log backup file which is created by system maint- Job.
    Ran LSbackup job.
    The result is Backup failed.
    Error msg:
    Message
    2015-12-03 07:49:42.07 *** Error: Could not retrieve backup settings for primary ID '997998ae-0df6-4c00-8451-4953e21c8136'.(Microsoft.SqlServer.Management.LogShipping) *** 2015-12-03 07:49:42.07 *** Error: Failed to connect to server "MyOldServerName".(Microsoft.SqlServer.ConnectionInfo) ***
    2015-12-03 07:49:42.07 *** Error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)(.Net SqlClient Data Provider) *** 2015-12-03 07:49:42.07 ----- END OF TRANSACTION LOG BACKUP -----
    I found an error.
    my old server name.
    So I dropped the old server and add current server name.
    EXEC sp_dropserver 'Old name'
    GO
    EXEC sp_addserver 'new name', 'local'
    GO
    Restart server.
    But still I face the same issue.
    Please help me to fix this ASAP
    It's still indicates the old name.
    • Edited by Aadhira Thursday, December 3, 2015 2:37 AM
    Thursday, December 3, 2015 2:33 AM

All replies

  • I ran this query it's shows the old name
    Select * from msdb.dbo.log_shipping_monitor_primary

    Thursday, December 3, 2015 2:42 AM
  • go run =>cmd-->

    sqlcmd -L   see which instance name is showing..

    To verify that the renaming operation has completed successfully

    check sql server.

    SELECT @@SERVERNAME AS 'Server Name';


    Please click Mark As Answer if my post helped.


    • Edited by AV111 Thursday, December 3, 2015 2:54 AM
    Thursday, December 3, 2015 2:49 AM
  • Hi,

    USE Master
    go
    Select ServerProperty('ServerName')
    Select @@ServerName
    Select primary_server from msdb.dbo.log_shipping_monitor_primary

    Do you get same server name after running above query?


    Please mark solved if I've answered your question, vote for it as helpful to help other users find a solution quicker
    Praveen Dsa | MCITP - Database Administrator 2008 | My Blog | My Page

    Thursday, December 3, 2015 5:22 AM