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
![](https://images.cnblogs.com/cnblogs_com/zencorn/SQL-Version.png)
2. Right click SQL Server Agent node in SQL Management Studio, then create new SQL job, paste you T-SQL into command area.
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
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.
- Make people around you successful is the biggest contribution to ourselves. -