This article is a mirror article of machine translation, please click here to jump to the original article.

Architect_Programmer_Code Agriculture Network»Architect › Database & Database › Microsoft SQL Server › SQLServer backups restore databases
View: 13862|Reply: 0

[Tips] SQLServer backups restore databases

[Copy link]
Posted on 11/26/2014 3:50:00 PM | | |
A well-known error occurs when backing up a database with the error message "is formatted to support 1 media families, but 2 media families are expected according to the backup device specification". As shown below:

The solution is to first select the file that was backed up last time, click Remove, remove the current backup file, and then click OK to back up. This will allow for proper backups. I have also read the reason in the Microsoft help documentation, but there is too much content and there is no time to look at it carefully.
When restoring, I found that I couldn't find the bak file in the folder, and it could only be displayed after selecting All Files(*). This may be the setting in the folder options that should be viewed by the system, yes the system does not show the file suffix. The details are as follows

It should also be noted that if there is a database with the same name as the current database backup in SQL Server, and the current database is overthrown, the mdf and ldf file names of the new database should be modified, otherwise the new database will overwrite the database with the same name




Previous:The safest way to change and delete SA accounts by default in the 2011 MSSQL2000
Next:sqlserver transaction replication adds new tables without reinitialization

Related Posts
Disclaimer:
All software, programming materials or articles published by Code Farmer Network are only for learning and research purposes; The above content shall not be used for commercial or illegal purposes, otherwise, users shall bear all consequences. The information on this site comes from the Internet, and copyright disputes have nothing to do with this site. You must completely delete the above content from your computer within 24 hours of downloading. If you like the program, please support genuine software, purchase registration, and get better genuine services. If there is any infringement, please contact us by email.
Mail To:help@itsvse.com