文章來源：http://www.zghlxwxcb.cn/news/detail-819671.html
文章來源地址http://www.zghlxwxcb.cn/news/detail-819671.html
backup.bat
sqlcmd -S MESSQL01 -i D:\DBBackup\backup.sql?bakup.SQL
DECLARE @preferredReplica INT
SET @preferredReplica = (SELECT
[master].sys.Fn_hadr_backup_is_preferred_replica('TJ_MES'))
IF ( @preferredReplica = 1 )
BEGIN
DECLARE @FileName varchar(1000)
SELECT @FileName = (SELECT 'D:\DBBackup\Files\TJ_MES' + convert(varchar(500), GetDate(),112) + '.bak')
BACKUP DATABASE TJ_MES TO DISK=@FileName
SELECT @FileName = (SELECT 'D:\DBBackup\Files\U4DMMES' + convert(varchar(500), GetDate(),112) + '.bak')
BACKUP DATABASE U4DMMES TO DISK=@FileName
SELECT @FileName = (SELECT 'D:\DBBackup\Files\OCEXFN_Eng' + convert(varchar(500), GetDate(),112) + '.bak')
BACKUP DATABASE OCEXFN_Eng TO DISK=@FileName
SELECT @FileName = (SELECT 'D:\DBBackup\Files\OCEXFN_sys' + convert(varchar(500), GetDate(),112) + '.bak')
BACKUP DATABASE OCEXFN_sys TO DISK=@FileName
SELECT @FileName = (SELECT 'D:\DBBackup\Files\OCEXFN_tmp' + convert(varchar(500), GetDate(),112) + '.bak')
BACKUP DATABASE OCEXFN_tmp TO DISK=@FileName
SELECT @FileName = (SELECT 'D:\DBBackup\Files\TEST_DB' + convert(varchar(500), GetDate(),112) + '.bak')
BACKUP DATABASE TEST_DB TO DISK=@FileName
END到了這里，關于windows server定時任務的文章就介紹完了。如果您還想了解更多內容，請在右上角搜索TOY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關文章，希望大家以后多多支持TOY模板網(wǎng)！
