We have a partitioned database that I'd like to get copied over on a semi-regular basis to another server for testing updates. Since the partitioning is based on a date column, the most current data exists in one file.
Is it possible to restore just one datafile from the backup to the other server?
Complicating issue: we use Symantec's BackupExec. If this is possible using plain ol' backup from SQL Server, I can probably get that done, though.