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
Development resources, articles, tutorials, code samples, tools and downloads for ASP.Net, SQL Server, Reporting Services, T-SQL, Windows, AWS, SAP HANA and ABAP


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'
Code



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



SQL Server

SQL Server 2019 Installation
download SQL Server 2019
download SQL Server 2017
download SQL Server 2016
download SQL Server 2014
download SQL Server 2012
MacOS ve SQL Server 2019


Copyright © 2004 - 2021 Eralper YILMAZ. All rights reserved.