Create SQL server job with SQL SERVER.
1. Make sure you SQL Server version by using some T-SQL .
SELECT SERVERPROPERTY('productversion'),
SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
select @@VERSION
SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
select @@VERSION
2. Right click SQL Server Agent node in SQL Management Studio, then create new SQL job, paste you T-SQL into command area.
declare @filename nvarchar(100)
set @filename='E:\David\BackUpProject\BackUpDBFolder\TestScarabGenDavid'+convert(char(10),getdate(),112)+'.bak '
BACKUP DATABASE [TestScarabGenDavid] TO DISK = @filename WITH NOINIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
set @filename='E:\David\BackUpProject\BackUpDBFolder\TestScarabGenDavid'+convert(char(10),getdate(),112)+'.bak '
BACKUP DATABASE [TestScarabGenDavid] TO DISK = @filename WITH NOINIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
3. You can define severals jobs and schedule them as one job sequence.
转载于:https://www.cnblogs.com/zencorn/archive/2010/12/17/1909229.html