DECLARE @CurrentTime VARCHAR( -),@FileName VARCHAR( $),@FileName2 VARCHAR( $),@FileName3 VARCHAR( $),@FileName4 VARCHAR( $),@FileName5 VARCHAR( $)SET @CurrentTime = REPLACE(REPLACE(REPLACE(CONVERT(VARCHAR,GETDATE(), -),'-','_'),' ','_'),':',"') --(TEMP2 Database full backup)SET @FileName = 'F:\Temp2_FullBackup_Partial1_' + @CurrentTime+'. bak'SET @FileName2 = 'F:\Temp2_FullBackup_Partial2_' + @CurrentTime+'. bak'SET @FileName3 = 'F:\Temp2_FullBackup_Partial3_' + @CurrentTime+'. bak'SET @FileName4 = 'F:\Temp2_FullBackup_Partial4_' + @CurrentTime+'. bak'SET @FileName5 = 'F:\Temp2_FullBackup_Partial5_' + @CurrentTime+'. bak'BACKUP DATABASE [Gongwuyuan] to DISK=@FileName,DISK=@FileName2,DISK=@FileName3,DISK=@FileName4,DISK=@FileName5 withFORMAT
The database is backed up into several data groups. The drive letter can be specified as any drive letter, and when the database is restored, all backup files are added to the backup location at once, as
SQL Server large Database backup method