Full Database Backup

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
/*----------------------------------------*/
--@Database: target database name
--@Path: target backup directory end by '/'
/*----------------------------------------*/
use master
go
declare @Database nvarchar(256),@Path nvarchar(2048)
select @Database=N'MobileSaleStatMain',@Path=N'D:/backup/'
declare @sql nvarchar(max)
select @sql =N'BACKUP DATABASE '+@Database+N'
TO DISK = '''+@Path+@Database+N'_Full_'+REPLACE(REPLACE(REPLACE(convert(nvarchar(30),getdate(),126),'-','_'),':','_'),'.','_')+N'.bak''
WITH
NOFORMAT,
INIT,
NAME = N''Full Database Backup'',
SKIP'
exec (@sql)
go

Differential Database Backup

differential backup base on complete backup, it’s mean you should have a full backup before do this.

1
2
3
4
5
6
7
8
9
10
use master    
go
declare @Database nvarchar(256),@Path nvarchar(2048)
select @Database=N'MobileSaleStatMain',@Path=N'D:/backup/'
declare @sql nvarchar(max)
select @sql =N'BACKUP DATABASE '+@Database+N'
TO DISK = '''+@Path+@Database+N'_DIFF_'+REPLACE(REPLACE(REPLACE(convert(nvarchar(30),getdate(),126),'-','_'),':','_'),'.','_')+N'.bak''
WITH
DIFFERENTIAL'
exec (@sql)