Skip to main content
3 of 5
Improved link
Paul White
  • 90.3k
  • 30
  • 424
  • 663

Drop all the non-essential objects, such as indexes, from the DB (or a copy of it).

Some further ideas on Stack Overflow in the Q & A Reducing Size Of SQL Backup?.

There are tools which will extract a referentially correct set of data from a DB. The one I used was for DB2, however. If I find a link for SQL Server I'll edit it in.

Michael Green
  • 25.1k
  • 13
  • 53
  • 98