When I try to restore a database abackup from a SQL Server 2000 to 2008 R2m, I get this error:
Actually, I don't quite get it. What does the error actually mean?
And how can I solve it?
migrated from stackoverflow.com Mar 4 '12 at 5:32
This question came from our site for professional and enthusiast programmers.
Your database has multiple filegroups. You can't just use the simple UI dialog to say "restore database"... you need to use
This will tell you the names and paths of the filenames within the backup. Once you know what they are, you can writ a command like:
I strongly recommend you become familiar with the
(It may also be the case that this is only a partial filegroup backup.)