如何备份部分表记录到另一台机器

<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 728x15, 创建于 08-4-23MSDN */google_ad_slot = "3624277373";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 160x600, 创建于 08-4-23MSDN */google_ad_slot = "4367022601";google_ad_width = 160;google_ad_height = 600;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

--建立链接服务器，并提供登录信息
--请修改@datasrc为备份服务名
execsp_addlinkedserver@server='backupserver',@srvproduct='',@provider='SQLOLEDB',@datasrc='servercomputername'
go
--请修改@rmtuser、@rmtpassword参数为备份服务器sqlserver登录帐号
execsp_addlinkedsrvlogin@rmtsrvname='backupserver',@useself='false',@locallogin=null,@rmtuser='sa',@rmtpassword='pass'
go


--把数据保存到备份服务器
--dbname应修改备份服务器名
insertintobackupserver.dbname.dbo.masterTable
 select*frommasterTable
   wherekeyFieldin('value1','value2')
go
insertintobackupserver.dbname.dbo.masterTableDetail
 select*frommasterTableDetail
   where(selectkeyFieldfrommasterTablewheremasterTableDetail.masterTableId=masterTable._id)in('value1','value2')
go

--删除本数据库记录
deletefrommasterTable
 wherekeyFieldin('value1','value2')
go
deletefrommasterTableDetail
 where(selectkeyFieldfrommasterTablewheremasterTableDetail.masterTableId=masterTable._id)in('value1','value2')
go

 
<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 728x15, 创建于 08-4-23MSDN */google_ad_slot = "3624277373";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 160x600, 创建于 08-4-23MSDN */google_ad_slot = "4367022601";google_ad_width = 160;google_ad_height = 600;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>