I have a large database with some tables that have largely static data. I need to make a new database on a different server with the same table structure with the static data tables intact (keys, etc.). The other tables must be empty. They're all in the same filegroup in the original database. I've done this once, by some sort of partial (copy only?) backup and changing filenames... but I've lost the script and I can't locate the original article (yes, I'm kicking myself).