Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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 ?

Regards

share|improve this question
add comment

2 Answers

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

share|improve this answer
add comment

Have look at this question over on DBA.se - 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
add comment

Your Answer

 
discard

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.