begin
–命名规则’文件名+月+日+年‘
set @SqlName=@DataName+replace(convert(varchar(50),getdate(),110),”-”,””)+”.bak”
set @url=”E:/Program Files/Microsoft SQL Server/MSSQL.1/MSSQL/Backup/”+@SqlName
set @sqlback=”backup database ”+@DataName +” to disk=”””+@url+””” with init”
set @iisname=”IIs”+replace(convert(varchar(50),getdate(),110),”-”,””)
set @osql=”osql -S”+@ServerIp+” -U”+@SqlloginName+” -P”+@SqlLoginPwd+” -dmaster -q””+@sqlback+”””
set @IISversion=”123”–//replace(convert(varchar(50),getdate(),120),”:”,”-)
set @IISBack=”iisback /Backup /s ”+@ServerIISIp+” /u ”+@ServerIIsName+” /p ”+@ServerIIsPwd+” /b ”+@iisname+” /v ”+@IISversion+””–远程备份IIS文件路劲
–其中 /S 代表远程计算机名称或者IP /U 代表用户 /p 代表密码 /b 代表备份名称 /V 代表你所备份的版本号 /e 代表对备份文件进行加密
set @IIsBackmd=”copy y:/”+@iisname+”.MD”+@IISversion+” ”+@MoveIIsPath+””
set @IIsBacksc=”copy y:/”+@iisname+”.SC”+@IISversion+” ”+@MoveIIsPath+””
set @Sqlpath=”copy q:/”+@SqlName+” ”+@MoveSqlPath+””
set @IISyshe=”net use y: //”+@ServerIISIp+”/”+@IIsShareFile+” “”+@ServerIIsPwd+”” /user:”+@ServerIISIp+”/”+@ServerIIsName+””
set @Sqlyshe=”net use q: //”+@ServerIp+”/”+@SqlShareFile+” “”+@ServerPwd+”” /user:”+@ServerIp+”/”+@ServerName+””
exec master..xp_cmdshell @IISBack–远程备份
exec master..xp_cmdshell @IISyshe –//建立网落映射IIS”
exec master..xp_cmdshell @IIsBackmd
exec master..xp_cmdshell @IIsBacksc
exec master..xp_cmdshell ”net use y: /delete”–删除映射
exec master..xp_cmdshell @osql–远程备份数据库
exec master..xp_cmdshell @Sqlyshe–//建立网落映射数据库”
exec master..xp_cmdshell @Sqlpath
exec master..xp_cmdshell ”net use q: /delete”–删除映射
END
end
‘
END
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Creat_Job]’) AND type in (N’P’, N’PC’))
BEGIN
EXEC dbo.sp_executesql @statement = N’
