MS-SQL Automatic Backup
1.Create sql file
USE xxxx
DECLARE @backupTime VARCHAR(20)
DECLARE @sqlCommand NVARCHAR(1000)
SELECT @backupTime=(CONVERT(VARCHAR(8), GETDATE(), 112)
+REPLACE(CONVERT(VARCHAR(5), GETDATE(), 114), ':', ''))
SET @sqlCommand = 'BACKUP DATABASE NTCGVOTE TO DISK=''C:\Database_Backup\xxxx_'
+ @backupTime+'.bak'''
EXECUTE sp_executesql @sqlCommand
GO
2.Create bat file
sqlcmd -S . -i c:\Database_Backup\xxxx.sql
3.設定排程