About "system. Data. sqlclient. sqlerror: the media set has two media clusters, but only one. All members must be provided.

<Doctype HTML public-wcdtd XHTML stricten httpwwwworgtrxhtmldtdxhtml-strictdtd>

Cause analysis:
1. During backup, the old path was not deleted. I added a new path and accidentally set it to two backup paths. SQL splits the backup files into two based on the two backup paths.
2. During restoration, both backup files must be loaded to the source data.
3. Manually change the restored path to the data folder path of the actual SQL statement.
4. If a database with the same name needs to be overwritten, modify the settings.

Solution:

1. Only one backup path is retained during backup to generate a backup file ~

2. You can use the following example to complete the restoration.
Restore database DB from disk = 'C: \ A. Bak', disk = 'C: \ B. Bak'
Multiple disks are used.

 

 

# Database Technology