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
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