I am looking for a solution on how to backup and restore a database for development. The database essentially contains a set of records and also binary data. The binary data is very large. I want to figure out a solution where I can most efficiently restore the data rows (not binary data) as quickly as possible.
My initial thoughts was two file groups. But I still would need to restore the binary data file group to bring the database online. I also thought about Snapshots.
What recommendations can you suggest as a back/restore/db design solution to this issue?