The database backup problem media set has two media clusters, but only one

Today, when I backed up the database, I found a problem. I used to think it was a problem with SQL Server. At that time, I was busy.

Ignore it. Now I want to back up the database and find the same problem again. It's really troublesome. It's always around you.

The error occurs for a long time. Let's briefly describe the cause of the error.

System. Data. sqlclient. sqlerror: the media set has two media clusters, but only one

 

System. Data. sqlclient. sqlerror:
Media set has2
Media Clusters,However, only1
. All members must be provided.(Microsoft. sqlserver. SMO ),The error occurs because I did not remove the default data path when backing up the database.

The default value is not removed.C: \ Program Files \ Microsoft SQL Server \ mssql.1 \ MSSQL \ backup. BakAnd adds a new path

The result is backed up to two copies, but they are dependent on each other, and you cannot restore them successfully.

 

Solution:Remember to clear the original default path during Backup,

 

Add the path you want to back up.