Full Database Backup

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
/*----------------------------------------*/
[email protected]: target database name
[email protected]: 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 '[email protected]Database+N'
TO DISK = '''[email protected]Path[email protected]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 '[email protected]Database+N'
TO DISK = '''[email protected]Path[email protected]Database+N'_DIFF_'+REPLACE(REPLACE(REPLACE(convert(nvarchar(30),getdate(),126),'-','_'),':','_'),'.','_')+N'.bak''
WITH
DIFFERENTIAL'
exec (@sql)