(Microsoft SQL Server, error: 3219)

MSSQL failed to restore the database. The prompt is as follows: Restore to and server failed. (Microsoft. sqlserver. SMO) Other information: handle exceptions → An exception occurs when you execute a Transact-SQL statement or batch processing. (Microsoft. sqlserver. connectionsinfo) cannot be selected. Used for this operation. The Restore database is terminating abnormally. (Microsoft SQL Server, error: 3219) when this error occurs, the procedure is: right-click Database, task, restore, files, file groups, Source Device (select backup file), specify backup file location, and add selected files. In the "Restore files and file groups" dialog box, click "OK" to see the preceding error. Correct steps: Right-click Database, task, recovery, database, Source Device (select backup file), specify backup file location, and add the selected file. In the "Restore database" dialog box, click "OK" to restore the database correctly. The main reason is that file and file group backup must be restored to the matching database restoration file and File Group Backup SQL Server. For details, see: the difference between restoring a database and restoring a file and a file group in the http://support.microsoft.com/kb/281122/zh-cn can be seen here Article: Http://www.cnblogs.com/zping/archive/2008/08/21/1272961.html