Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Link Server

Author  Topic 

pdset
Constraint Violating Yak Guru

310 Posts

Posted - 2011-09-06 : 23:36:18
Previously, we do have link server connection from 2008 (Log Shipping) to 2005 (Clustered) servers.

After that 2005 has been decommissioned and still the link server connection from 2008 version existing.

Will this connection causes any extra load (though not existing), if so what kind of repurcussions would arise.

Please advise and thanks.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-09-07 : 13:30:50
It will not cause any extra load as nothing is using it. Why don't you just delete it though?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -