SQL SERVER – Fix Error 7202 Could not find server in sys.servers. Verify that the correct server name was specified
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.
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'
No comments:
Post a Comment