sqlserver 跨服务器备份表

时间:2019-11-09 00:39来源:快三在线投注平台数据库
exec sp_configure 'show advanced options',1 reconfigure exec sp_configure 'Ad Hoc Distributed Queries',1 reconfigure SELECT * into T_System_Organization_bak_20180308 from openrowset ('SQLOLEDB' , '10.***.***.***,端口 ; '用户名' ;'密码

exec sp_configure 'show advanced options',1 reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1 reconfigure
SELECT * into T_System_Organization_bak_20180308
from openrowset ('SQLOLEDB' , '10.***.***.***,端口 ; '用户名' ; '密码' ,[数据库名称].dbo.表名)
exec sp_configure 'Ad Hoc Distributed Queries',0 reconfigure
exec sp_configure 'show advanced options',0 reconfigure

编辑:快三在线投注平台数据库 本文来源:sqlserver 跨服务器备份表

关键词: