Restore a Linked Server from backup

A linked server has been (accidentally) removed from a SQL Server instance and nobody knows the credentials to r开发者_如何学Ce-create it from scratch.

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

the system view sys.servers contains the details you need, however, I'm not sure if a restore of master or msdb will give you that.

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.