Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have actually a small Production Filestream enabled database. Data (150 Mo) + Filestream (500 Mo).

Tomorow, the filestream will grow until 30 Go...

I have many Test Databases that I want to restore with Production dump.

Is it possible to restore production data without Filestream ? Developper don't want blob, image, video...

I can I do ?


share|improve this question

You can not. Back/Restore is for backup/restore, not to give partial data to developers.

share|improve this answer

Have look at this question over on - it has a couple suggestions for how to work around this type of issue that might be useful to you. (Basically, you can hide the data with a view, but not leave it out of the restore, as this would leave the database in an inconsistent transactional state.)

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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