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
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.
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':
...and add all Striped Backup files:
Click 'OK' to restore the database:
Read related article:
Difference between Mirrored and Striped Database Backups in SQL Server