SQL bit-by-bit backup and database restoration tips

Editor's note: when using SQL Server, a small error occurs in backup and database restoration. What should you do? Here are a few tricks. Let's take a look at them with the author!

An unknown error occurred while backing up the database. the error message is "is formatted to support 1 media families, but 2 media families are expected according to the backup device specification ". For example:

The solution is to first select the last backup file, click Remove, Remove the current backup file, and then click OK to back up. In this way, you can back up the data correctly. I have also read the reason in the help documentation of Microsoft. I have too much content to take a closer look.

Restoring the database encountered a trick in the database. When restoring the database, we found that the bak file could not be found in the folder. After selecting All Files (*), the file will be displayed. This may be the setting in the System View folder option. Yes, the system does not display the file suffix. For details, see

 

Note that if SQL Server has a database with the same backup name as the current database and overwrites the current database, you should modify the mdf and ldf File Name of the new database, otherwise, the new database will overwrite the database with the same name, for example.