When you find yourself loading several gigabytes of database backups from production to a test environment or development chances are that most of that data is binary files in the blob table.
If these files are not image files you most likely won't need them for test or development.
So for stripping the excessive binary in your database you could opt for this Sql Script approach.
No comments: