sql server 备份脚本（SQL Server备份脚本）.docVIP

sql server 备份脚本（SQL Server备份脚本） Because of my work, I need to write a backup script for the SQL Server database. The function I need to implement is: 1. make full backup / incremental backup of the database according to plan 2. place different backups on different backup devices (for example, backups are stored on a single backup device each day) 3. save the backup contents on other machines I found some information on the Internet, but most of them havent written anything like that. After two days of writing and testing, I finally got it The function of implementation is: 1. place the scripts you need to execute into the scheduled task. Adjust the run time as needed 2. each time the backup content generates a separate device name, the date file name is used to determine 3., the backup of the content of FTP to other computers. This is also to make a small offsite disaster tolerance, not in a machine finished. Database backup is not Here are the contents of the two scripts. Welcome to give your opinions and suggestions Also, Im not responsible for the consequences of running any of these scripts, but there are technical issues that are welcome to communicate if I have the time and I know The script is divided into two parts, the 1 is fully backed up, and the other is differential backup @ECHO off REM!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! REM, Differential, Backup, SQL, server, database REM email:hao.wangbj@ REM blog: REM Date:REM!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! ECHO. REM, Backup, Database, Script, Log, Files SET logdir=c:\1 If, not, exist,%logdir%\nul, MKDIR,%logdir% REM B_SCRIPT_TARGET SET B_SCRIPT_TARGET=c:\2 If, not, exist,%B_SCRIPT_TARGET%\nul, MKDIR,%B_SCRIPT_TARGET% REM B_DataFiles_TARGET SET B_DataFiles_TARGET=c:\3 If, not, exist,%B_DataFiles_TARGET%\nul, MKDIR,%B_DataFiles_TARGET% REM Backup Database Name SET B_Database_Name=testdb SET B_DATE=%date:~0,4%%date:~5,2%%date:~8,2% ECHO use master; %B_SCRIPT_TARGET%\DIFFERENTIAL_backup.sql ECHO g