Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Filegroup b/u and restore, need help

Status
Not open for further replies.

icemel

MIS
Oct 17, 2005
463
US
Hi,

I am experimenting with filegroup backup and restore. On a test machine here, I did a backup of a single filegroup to a local disk. (SQL Server 2005)

I then removed the backed-up filegroup from the database using 'ALTER DATABASE ... REMOVE FILE myFileGroup'

Everything went fine until I attempted to restore the filegroup (the one I had just backed up).

This is the error message I received:

The mediaset has 2 families, but only 1 are provided. All members must be provided.

Ok, so what am I doing wrong here?

THANKS
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top