• So, it's still not really clear to me... I want to attach to a db (very large, sql 2000) on another server and create an empty db on the new server (which is sql 2005) which has limited disk space. What is the best way to do this? Is there a way to restore with no data?

    In addition, I require a subset of data. To get a subset I'll likely have to copy the extract sql and use that to create an extract script of my own for testing. Better ideas?

    Thanks