SQL Server: "This filegroup cannot be used as a backup destination" error when attempting restore
Posted
by
Ariel
on Server Fault
See other posts from Server Fault
or by Ariel
Published on 2010-07-09T17:54:18Z
Indexed on
2011/01/01
17:56 UTC
Read the original article
Hit count: 456
sql
|sql-server
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.
© Server Fault or respective owner