1

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.

3
  • 1
    As you are getting an error message I would assume that is the case.
    – mrdenny
    Jul 9, 2010 at 23:56
  • do you get the error when your attempting a restore?, or when your attempting the list the files in the backup? (i.e. your first command) Jul 10, 2010 at 13:49
  • Nick - when attempting a restore, see above. Thanks.
    – Ariel
    Jul 11, 2010 at 23:32

1 Answer 1

0

This has been noted as a bug by Microsoft. It is scheduled to be fixed in the future.

http://connect.microsoft.com/SQLServer/feedback/details/591263/unable-to-perform-backups-to-server-that-has-network-share-filestream-hdr

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .