Search code examples
sqlsql-serverbackuplinked-server

Restore a Linked Server from backup


A linked server has been (accidentally) removed from a SQL Server instance and nobody knows the credentials to re-create it from scratch.

So, is there a way to restore the linked server from a backup (presumably msdb) taken before its deletion?


Solution

  • I have finally used details in master.dbo.sysservers (SQL Server 2000) to recreate the linked server and created new credentials in order to connect.

    Thanks for the comments.