By using Ms SQL Server any edition you can create a full backup to multiple disk file, which is the best solution. In a steps of one Job you can do it by using this Transact SQL, as it follows:
BACKUP DATABASE HealthInsuKS
TO DISK = ‘C:\HealthInsuKS_1.BAK’ ,
DISK = ‘D:\HealthInsuKS_2.BAK’ ,
DISK = ‘E:\HealthInsuKS_3.BAK’ ,
GO
This T-SQL uses the DISK option multiple times to write to three equally sized smaller files.
Leave a Reply