SQL Server Performance

logshipping error

Discussion in 'SQL Server 2005 Log Shipping' started by Akthar, Jun 5, 2007.

  1. Akthar New Member

    Hi all,

    i am trying to setup log Shipping on SQL 2005. In fact i have rename my server and i am unable to setup log shipping:

    Saving secondary destination configuration [servername].[test] (Error)
    Messages
    SQL Server Management Studio could not save the configuration of 'ServerName' as a Secondary. (Microsoft SQL Server Management Studio)
    ------------------------------
    ADDITIONAL INFORMATION:

    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

    ------------------------------

    The specified @server_name ('OLDServername') does not exist.
    The specified @server_name ('OLDServerName') does not exist.
    The specified @server_name ('OLDServerName') does not exist. (Microsoft SQL Server, Error: 14262)


    AKTHAR
  2. MohammedU New Member

    If you rename your server recently you have to run ...

    sp_dropserver 'oldservername'
    go
    sp_addserver 'newserver', 'local'

    and restart the sql services...


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  3. Akthar New Member

    works fine thanks

    AKTHAR

Share This Page