Answered by:

Restoring a file group database in SQL 2005 Server

Question

I have an SQL Server 2005 database file group database that I'm trying to restore. When I do a syntax check the from/source statement of the restore continues to have errors. I have the following code:

Yes I'm trying to restore the entire database. Since a file group database where the groups are spread across multiple drives shouldn't I be doing the above?

Nope. Just RESTORE the database. Add WITH MOVE clauses for any files that you want to put in a different folder than they were in where and when the backup was taken.

The SSMS Restore Database Wizard will walk you through it. But instead of running the restore through the wizard, hit the "Script" button and it will generate a TSQL script for you to examine and run in a query window.

I’m writing to follow up with you on this post. If you have any other question, you can open a new thread in the forum. I’d like to mark this issue as "Answered". Please also feel free to unmark the issue, with any new findings or concerns you
may have. Thanks.