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.
