Split Database Backup Into Multiple Files In SQL Server 2008

In this article I tell you how to split database backup into multiple files.
  • 2652

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

DatabaseBackup1.jpg

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

DatabaseBackup2.jpg

Now see the location where backup is created.

 DatabaseBackup3.jpg

 

Categories

More Articles

© 2019 DotNetHeaven. All rights reserved.