-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
  • 51,649
  • 7
  • 54
  • 136
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,795
  • 33
  • 135
  • 209