sqlserver 較大Database Backup方法

標籤：ack   ima   color   技術   SQ   資料庫   arc   添加   filename   

DECLARE @CurrentTime VARCHAR(50), @FileName VARCHAR(200),@FileName2 VARCHAR(200),@FileName3 VARCHAR(200),@FileName4 VARCHAR(200),@FileName5 VARCHAR(200)SET @CurrentTime = REPLACE(REPLACE(REPLACE(CONVERT(VARCHAR, GETDATE(), 120 ),‘-‘,‘_‘),‘ ‘,‘_‘),‘:‘,‘‘)        --(Temp2 資料庫完整備份)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=@FileName5WITH FORMAT

將Database Backup為幾份便就分成幾個資料群組。盤符可指定為任意盤符，還原資料庫時候，將所有備份檔案一次性添加到備份位置下，如

 

sqlserver 較大Database Backup方法