国产亚洲精品a在线看。,骚货想不想被艹,国产麻豆剧传媒兔子先生,好大好爽好想要被操视频

以文本方式查看主題

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

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

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

-- 異地備份

-- 第一步：使用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