Is there a way to do a selective restore? I need to create a dev db and the prod backup is 17 gig and I have a space crunch on the server. My idea was to restore the complete backup and subsequently shrink the db size after truncating data in tables which are not frequently used? Is that a good idea. Any help will be appreciated.
1. Create database script (including user, permissions, etc.) and use it for creating database on another server.
2. Use DTS for transferring data to tables (for biggest tables use option - use a query to specify the data for transfer).
During transfer you could disable FOREIGN KEYs if any.