locked
SQL 2005 File Group Backup and Restore RRS feed

  • Question

  • I'm running SQL Server 2005 Enterprise Edition (x64) on a Windows 2003 Enterprise Edition (x64) machine.  I have a database that is constructed as a file group.  That being said when I backup my database is use file group option to create a backup. 

    Because is use the file group option to backup my database I'm using the file group option to execute a restore.  When I run the restore option using Studio Manager I get the following error:

    The  file or filegroup "XXDB_log" cannot be selected for this operation. RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3219).

    I've read a log to post on the web but for some reason I'm not getting why the restore does not work. 

    Should I not be using the file group option for a database that is made up of files vs a single file?

    How do I restore a database that uses the file group option?

    Thanks

    Wednesday, May 29, 2013 12:51 PM

Answers