how to create smaller version of production database


  • I have 200+GB Production database and I get a task to create a smaller version of database for QA / Dev every night. 

    can any one suggest what is the best way or approach is.

    Issues is there are lots of tables with constraint and I need one last one week data and then remove all other data as table size is too big so delete will not work.

    Thursday, February 20, 2014 2:56 PM