SQL Server: "This filegroup cannot be used as a backup destination" error when attempting restore
- by Ariel
When running a command like the following:
"RESTORE FILELISTONLY FROM DISK='\\\\server\\folder\\DummyDB.bak'"
I'm getting this error:
Backup destination "\\server" supports a FILESTREAM filegroup. This filegroup cannot be used as a backup destination. Rerun the BACKUP statement with a valid backup destination.
RESTORE FILELIST is terminating abnormally.
Unless someone comes up with a better idea, it seems that the drive from which restore is being attempted must not contain any database file contained in a filegroup. Is that the case? Thanks in advance.