Skip to main content
4 of 5
replaced http://stackoverflow.com/ with https://stackoverflow.com/

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