Quick Restore Solution of Partial Data

  • 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?

  • looks good idea

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply