Grant is right about the indexes and transaction logs. Be sure the database is in simple mode, and run the DBCC ShrinkDatabase(<databasename>, 10) to recover any disk space that may be available from the log commitments. You mentioned that it is UAT. What are the testing requirements? Do you need to do a load test? Can you cull down the data, based on a date field? I just went throught this excercise on a development system. I asked our business users for the primary filter criteria, which turned out to be Member State. I applied a filter that focused on just 3 states for claims data. Once I deleted all the unwanted data and did a ShrinkDatabase, I reduced the database size on disk from 222GB to 74GB. :w00t: