MSSqlserver分割文件备份恢复

-- 分割文件备份

DECLARE @CurrentTime VARCHAR(50), @FileName VARCHAR(200),@FileName2 VARCHAR(200),@FileName3 VARCHAR(200),
@FileName4 VARCHAR(200),@FileName5 VARCHAR(200),@FileName6 VARCHAR(200)
SET @CurrentTime = REPLACE(REPLACE(REPLACE(CONVERT(VARCHAR, GETDATE(), 120 ),'-','_'),' ','_'),':','')

--(Test 数据库完整备份)
SET @FileName = 'D:\分割备份\A\' + @CurrentTime+'.bak'
SET @FileName2 = 'D:\分割备份\B\' + @CurrentTime+'.bak'
SET @FileName3 = 'D:\分割备份\C\' + @CurrentTime+'.bak'
SET @FileName4 = 'D:\分割备份\D\' + @CurrentTime+'.bak'
SET @FileName5 = 'D:\分割备份\E\' + @CurrentTime+'.bak'
SET @FileName6 = 'D:\分割备份\F\' + @CurrentTime+'.bak'

BACKUP DATABASE [Test]
TO
DISK=@FileName,
DISK=@FileName2,
DISK=@FileName3,
DISK=@FileName4,
DISK=@FileName5,
DISK=@FileName6
WITH FORMAT

 

/* --查询备份文件
RESTORE FileListOnly From Disk='D:\分割备份\A\.bak'
RESTORE FileListOnly From Disk='D:\分割备份\B\.bak'
RESTORE HeaderOnly From Disk='D:\分割备份\C\.bak'
RESTORE HeaderOnly From Disk='D:\分割备份\D\.bak'
RESTORE HeaderOnly From Disk='D:\分割备份\E\.bak'
RESTORE HeaderOnly From Disk='D:\分割备份\F\.bak'
*/

USE [master]
RESTORE DATABASE [Test]
FROM
DISK = N'D:\分割备份\A\.bak',
DISK = N'D:\分割备份\B\.bak',
DISK = N'D:\分割备份\C\.bak',
DISK = N'D:\分割备份\D\.bak',
DISK = N'D:\分割备份\E\.bak',
DISK = N'D:\分割备份\F\.bak'
WITH FILE = 1,
MOVE N'Test' TO N'E:\DataBase\Test.mdf',
MOVE N'Test_log' TO N'E:\DataBase\Test_log.ldf',
NOUNLOAD, REPLACE, STATS = 5

GO