"Unable to select a file or filegroup Xxx_log for this action," The SQL Server 2005 restore database appears

SQL2005 restoring the database failed with the following: "Cannot select File or filegroup Xxx_log workaround for this action when SQL Server 2005 restores the database"

when an error occurs , right-click the database---task---restore---file and filegroup---Source device (select backup file)---Specify the backup file location---to add the selected file. The error shown above appears when you click the OK button in the Restore Files and Filegroups dialog box.

the correct steps are: Right-click the database---task---restore---database---Source device (select backup file)---Specify the backup file location---to add the selected file. You can restore it correctly by tapping the OK button in the Restore Database dialog box.

Note At this time the database does not make any queries, need exclusive to restore!

Http://www.cnblogs.com/Fooo/p/3482618.html

"Unable to select a file or filegroup Xxx_log for this action," The SQL Server 2005 restore database appears