-1

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

alain
  • 7
  • 1
  • 2

2 Answers2

0

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

TomTom
  • 50,857
  • 7
  • 52
  • 134
0

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.)

Community
  • 1
HopelessN00b
  • 53,385
  • 32
  • 133
  • 208