Restore Linked Servers

[ronnetp]

I need to Install a New Server SQL2000 on Windows200 server, I have Backups of everything from the old SQL2000 server on Windows2000 Server, I already reinstalled the DBs and
MSDB, all the DTS and jobs appear, but I dont see the
linked Servers.

Anyone can help, on how to bring the Linked Server info from the old server to the new installation

Thanks

 

[JayKusch]

I do not beleive there is a way to script out the already created linked servers from an instance of SQL Server ... but you never know !!! LOL

You may have to create you own script by using sp_add_linkedserver in this fashion ...

EXEC sp_addlinkedserver
   @server=LINKEDSERVER,
   @srvproduct = 'SQLServer OLEDB Provider',
   @provider = 'SQLOLEDB',
   @datasrc = 'JKusch'

Thanks

J. Kusch

 

[ronnetp]

Manually Ouch, well if there is no way,

I will stay with this one,

Thanks JAY