Restore a SQL Server Database from Striped Backup Files

To restore a SQL Server Database from Striped (Split) Backup Files made using the following backup command:

BACKUP DATABASE [AdventureWorks]
TO DISK = N'C:\Backup\AdventureWorks.bak',
DISK = N'D:\Backup\AdventureWorks.bak'
WITH NOFORMAT;
GO

...use this Restore command:

RESTORE DATABASE [AdventureWorks]
FROM DISK = N'C:\Backup\AdventureWorks.bak',
DISK = N'D:\Backup\AdventureWorks.bak';
GO

restore_striped

If you don't specify all striped (split) backup files in the RESTORE command, you will get the following error:

Msg 3132, Level 16, State 1, Line 1
The media set has 2 media families but only 1 are provided. All members must be provided.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

restore_striped_error

To restore restore a SQL Server Database from Striped (Split) Backup Files using SQL Server Management Studio (SSMS):

Right click on a database -> choose ‘Tasks’ -> ‘Restore’ -> 'Database'
In the 'Restore Database' dialog box, choose 'Device':

restore_striped_add_backup_files_from_device

...and add all Striped Backup files:

restore_striped_select_backup_devices

Click 'OK' to restore the database:

restore_striped_ssms

Read related article:
Difference between Mirrored and Striped Database Backups in SQL Server

If the post helped you, please share it:
Pin It

1 comment to Restore a SQL Server Database from Striped Backup Files

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">