up vote 1 down vote favorite
share [g+] share [fb]

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.

link|improve this question
27% accept rate
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
feedback

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

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

1 Answer

up vote 0 down vote

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

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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