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)