SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software Kodyaz SQL Server Tools Reviews and Tutorials
Development resources, articles, tutorials, samples, codes and tools for .Net, SQL Server, Vista, etc.




download SQL Server 2014



Split Backup in SQL Server into Multiple Files

In order to split backup in SQL Server into multiple files, database administrators can use T-SQL Backup Database command as well as SQL Server Management Studio Back up Database Task Wizard

Here is how to backup SQL database into separate files using SQL Backup Database command.

BACKUP DATABASE AdventureWorks2008R2 TO
DISK = 'C:\SQL-Backup\DatabaseBackupFile1.back',
DISK = 'C:\SQL-Backup\DatabaseBackupFile2.back',
DISK = 'C:\SQL-Backup\DatabaseBackupFile3.back'



Here is how database administrators can split SQL Server database backup into multiple files in SQL Server 2008 using SSMS

Open SQL Server Management Studio.
Connect to SQL Server database instance where your target database resides.
Open context menu by a right-click on the sql database which you want to take its backup file
From the context menu, choose Tasks > Backup ... menu options

split backup file into multiple files

The above SQL backup task selection for your database will open the Back Up Database wizard dialog screen.

In the Backup Destination section of the SQL Back up database task screen, provide more than a single file as seen in the below screenshot.

Since I want to split backup file into 5 backup files, I provided 5 separate files as backup destination :
C:\SQL-Backup\AdventureWorks2008R2.backup1
C:\SQL-Backup\AdventureWorks2008R2.backup2
C:\SQL-Backup\AdventureWorks2008R2.backup3
C:\SQL-Backup\AdventureWorks2008R2.backup4
C:\SQL-Backup\AdventureWorks2008R2.backup5

split backup in SQL Server 2008

After you enter different destination file names in order to split sql backup files, click on OK button to start backup database task

backup sql database into separate files






Follow Kodyaz on Twitter

Related SQL Resources

SQL Server Articles

SQL Server 2012

SQL Server Tools

SQL Blog

SQL Server 2008 Blog

Certification Exams Blog

Reporting Services Blog

Analysis Services Blog

MS SQL Server Forums



Free Exam Vouchers










Copyright © 2004 - 2014 Eralper Yilmaz. All rights reserved.
Community Server by Telligent Systems