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.

migrated from stackoverflow.com Jul 9 '10 at 23:46

This question came from our site for professional and enthusiast programmers.

  • 1
    As you are getting an error message I would assume that is the case. – mrdenny Jul 9 '10 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) – Nick Kavadias Jul 10 '10 at 13:49
  • Nick - when attempting a restore, see above. Thanks. – Ariel Jul 11 '10 at 23:32
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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.