This topic has been archived. It cannot be replied.
-
工作学习 / 专业技术讨论 / 大过年的， 也不知道还有人不? sql server 2000, linked server的问题见内用sp_addlinkserver连接上了， 可有时候连接自己就断了， 请问怎么获得这个断了的信息呢? 老接到投诉才知道， 头大呢。。。。
多谢多谢， 新年发财!
-zxcvb(朝天椒);
2006-12-30
{141}
(#3402262@0)
-
is it a 24/7 server? if not, you can use DTS to maintain it every night.
-sunday8(sunday8);
2006-12-30
(#3402385@0)
-
24/7 :(
-zxcvb(朝天椒);
2006-12-30
(#3402446@0)
-
you can active pull the linked server every 15 mins from DTS. (it shouldn't cost too much server resource.) if the linkserver drops, you can recreate it.
-sunday8(sunday8);
2006-12-30
(#3402501@0)
-
谢谢， 请问怎么知道linked server drop了呢?
-zxcvb(朝天椒);
2006-12-30
(#3402680@0)
-
if exists(select * from sysservers where srvName='YOURLINKEDSERVER')
-sunday8(sunday8);
2006-12-30
(#3402713@0)
-
thanks a lot
-zxcvb(朝天椒);
2006-12-30
(#3402812@0)
-
再问sql server 高手， 如果有个linked server (sql server 2000), 当对方的server stoped, 我从我的server上面怎么检测到? 谢谢指点!
-zxcvb(朝天椒);
2007-1-2
(#3406481@0)
-
up
-zxcvb(朝天椒);
2007-1-2
(#3406514@0)
-
fyi
-ice(草根丁);
2007-1-2
(#3406557@0)
-
谢谢， 很受启发
-zxcvb(朝天椒);
2007-1-2
(#3406633@0)
-
2000对2000好像还是没有办法噢:(
-zxcvb(朝天椒);
2007-1-2
(#3407083@0)
-
一到这会儿，高手们全都翘了........
-ice(草根丁);
2007-1-2
(#3407131@0)
-
谢谢anyway. 再up.....呼叫高手~~~~
-zxcvb(朝天椒);
2007-1-2
(#3407243@0)
-
写一个telnet的批处理文件，telnet 远端 sql server的端口。然后在sql job里添加这个批处理文件，加上on succeed or on failure 的处理就应该可以了。
-hard20(hard20);
2007-1-2
(#3407688@0)
-
谢谢， 踢掉了已经， 松口气
-zxcvb(朝天椒);
2007-1-5
(#3413507@0)
-
try SMO.
-sunday8(sunday8);
2007-1-5
(#3412436@0)
-
谢谢， 踢掉了已经， 松口气
-zxcvb(朝天椒);
2007-1-5
(#3413508@0)