The other day I received following error when I tried to restore a database from one server to another server.
Msg 7202, Level 11, State 2, Line 1
Could not find server ‘MyLinkedServer’ in sys.servers. Verify that the correct server name was specified.
Well, this is quite a popular error one receive when they attempt to restore database containing references of the linked server. The solution is to create a link server and restore database. Here is the quick script which can fix your error.
EXEC sp_addlinkedserver @server='MyLinkedServer'
EXEC sp_addlinkedsrvlogin 'MyLinkedServer', 'false', NULL, 'MyUserName', 'MyPassword'
Well, that’s it. Sometimes the solution is much simpler, even though the original problem looks complicated.
Reference: Pinal Dave (http://blog.SQLAuthority.com)