在线播放亚洲第一字幕,国产大片在线观看黄不卡,中文字幕亚洲欧美无线码,日本一区二区视频不卡免费

以文本方式查看主題

-  昂捷論壇  (http://www.yzsenyi.com/bbs/index.asp)
--  □-系統(tǒng)配置管理類  (http://www.yzsenyi.com/bbs/list.asp?boardid=34)
----  問：簡單做異地備份的腳本是怎樣的？  (http://www.yzsenyi.com/bbs/dispbbs.asp?boardid=34&id=3980)

--  作者：飛絮
--  發(fā)布時間：2008/6/3 22:18:23
--  問：簡單做異地備份的腳本是怎樣的？

答：在數(shù)據(jù)庫任務(wù)中以以下腳本可實現(xiàn)數(shù)據(jù)庫的定時備份：

-- 異地備份

-- 第一步：使用net命令連接異地服務(wù)器
-- To allow advanced options to be changed.
EXEC sp_configure \'show advanced options\', 1
GO
-- To update the currently configured value for advanced options.
RECONFIGURE
GO
-- To enable the feature.
EXEC sp_configure \'xp_cmdshell\', 1
GO
-- To update the currently configured value for this feature.
RECONFIGURE
GO

EXEC xp_cmdshell \'net use \\\\192.168.1.6\\d$\\shq_bak password /user:administrator\',no_output

-- 第二步：執(zhí)行備份

declare @day int
set @day = datepart(weekday,getdate())
if (@day in (3,5,7)) begin
backup database enjoy_shq to disk=\'\\\\192.168.1.6\\d$\\shq_bak\\enjoy_shq01.bak\' with init
end else if (@day in (2,4,6)) begin
backup database enjoy_shq to disk=\'\\\\192.168.1.6\\d$\\shq_bak\\enjoy_shq02.bak\' with init
end else begin
backup database enjoy_shq to disk=\'\\\\192.168.1.6\\d$\\shq_bak\\enjoy_shq01.bak\' with init
end