SQL Server Performance Forum – Threads Archive

logshipping error

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

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.

works fine thanks AKTHAR

]]>