Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004

    Question Unanswered: Selective restore

    Hello all,
    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.

    Thanks in advance!

  2. #2
    Join Date
    Jul 2002
    Village, MD
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts