MSSQL Server Database Tutorial Backup statements
DECLARE @exec_str varchar (60)
DECLARE @exec_str_rar varchar (60)
DECLARE @exec_str_diff varchar (60)
DECLARE @exec_str_rar_diff varchar (60)
DECLARE @DEL_DATE_4 char (8)
Select @DEL_DATE_4 = Convert (char (8), DATEADD (Dd,-4,getdate ()), 112)
--Processing database SZC 4 days with additional preparation
Select @exec_str = ' del F:db_backxtoadb_full_ ' + @DEL_DATE_4 + '. Bak '
Select @exec_str_rar = ' del D:db_back_rarxtoadb_full_ ' + @DEL_DATE_4 + '. rar '
Select @exec_str_diff = ' del f:db_backdifferentxtoadb_diff_ ' + @DEL_DATE_4 + ' *.bak '
Select @exec_str_rar_diff = ' del d:db_back_rardifferentxtoadb_diff_ ' + @DEL_DATE_4 + ' *.rar '
EXEC master.. xp_cmdshell @exec_str, No_output
EXEC master.. xp_cmdshell @exec_str_rar, No_output
EXEC master.. xp_cmdshell @exec_str_diff, No_output
EXEC master.. xp_cmdshell @exec_str_rar_diff, No_output
--Processing database szcstatistics 4 days
Select @exec_str = ' del f:db_backxtoadbstatistics ' + @DEL_DATE_4 + '. Bak '
Select @exec_str_rar = ' del d:db_back_rarxtoadbstatistics ' + @DEL_DATE_4 + '. rar '
EXEC master.. xp_cmdshell @exec_str, No_output
EXEC master.. xp_cmdshell @exec_str_rar, No_output
--Processing database Szclog 4 days
Select @exec_str = ' del f:db_backxtoadblog ' + @DEL_DATE_4 + '. Bak '
Select @exec_str_rar = ' del d:db_back_rarxtoadblog ' + @DEL_DATE_4 + '. rar '
EXEC master.. xp_cmdshell @exec_str, No_output
EXEC master.. xp_cmdshell @exec_str_rar, No_output
Go
--2. Step Two: Database backup processing
Select ' Backup start time: ' = GETDATE ()
Declare @RCL_DATE char (8)
Select @RCL_DATE = Convert (char (8), GETDATE (), 112)
D Eclare @PATH varchar
--Backup of database SZC--With differential backup
Select @PATH = ' f:db_back ' + ' Xtoadb_full_ ' + @RCL_DATE + '. Bak '
Backup LOG xtoadb with TRUNCATE_ONLY
Snapup db xtoadb to DISK = @PATH with INIT
-database Szcstatistics backups
Select @PATH = ' f:db_back ' + ' xtoadbstatistics ' + @RCL_DATE + '. Bak '
--backup LOG xtoadbstatistics with TRUNCATE_ONLY
--backup db xtoadbstatistics to DISK = @PATH
--Backup of database Szclog
Select @PATH = ' f:db_back ' + ' Xtoadblog ' + @RCL_DATE + '. Bak '
--backup LOG xtoadblog with TRUNCATE_ONLY
--backup the DATABASE xtoadblog to DISK = @PATH
go? "