Split Database Backup Into Multiple Files In SQL Server 2008
In this article I tell you how to split database backup into multiple files.
In this article I tell you how to split database backup into multiple files. Sometimes there is need to run database on different systems. It will be very time consuming to create database again and again. Also for security purpose we need to create full database backup that can be restore when needed.
Step 1
Create complete Backup
SET STATISTICS IO ON
SET STATISTICS TIME ON
BACKUP DATABASE person
TO DISK = 'D:\swati\ReportServer.bak'
SET STATISTICS IO OFF
SET STATISTICS TIME OFF
Result
Step 2
Split Database Backup
SET STATISTICS IO ON
SET STATISTICS TIME ON
BACKUP DATABASE person TO
DISK = 'D:\swati\ReportServer_Part1.bak'
,DISK = 'D:\swati\ReportServer_Part2.bak'
,DISK = 'D:\swati\ReportServer_Part3.bak'
SET STATISTICS IO OFF
SET STATISTICS TIME OFF
Now see the location where backup is created.
