Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
IK1972
56 Posts |
 Posted - 2014-02-20 : 09:53:27
|
| 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.Thanks |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2014-02-20 : 11:57:47
|
| How about start with an empty copy of the database (in production). Then insert a week's worth of data from the live db to the devqc copy - in the correct table order so you don't violate FK constraints. Then take a backup of that dev/qc database and distribute as needed.I wonder why you want a fresh copy every night? Seems like an occasional refresh should be sufficient. what if folk's dev and testing needs to span several days?Be One with the OptimizerTG |
 |
|
|
|
|
|
how to create smaller version of production databa