MS SQL Server, selective backup tool

view full story

http://serverfault.com – I'm looking for an enterprise tool / product - paid or free that is designed to handle selective backup / restore of massive MS SQL Server databases. A simple usage scenario would be - from our prod database, to daily have a dev database restored with only a subset of data from Prod. This needs to be configured on a table by table basis. So certain tables can restore with more historic data than others, while some will just be completely excluded. I'll be clear - what I don't want is a tool that does a complete backup, and then follows this up with truncate or delete commands. I'm ideall (HowTos)