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 |
|
jgandara
Starting Member
18 Posts |
 Posted - 2004-03-19 : 12:09:39
|
| What is the best approach to keep a testing database with fresh data?We do daily full backups of the production DB. The full backup's size is 7G.Should I do a restore of the full backup? I was thinking about just copying some records from each table, but it can lead to inconsistencies and I have to deal with constrains. I’d run the process once a month, or as required, in case we need to test something important with “real” data.What is the best approach to this? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-19 : 12:22:08
|
| Yes, I would just perform a restore using the FULL BACKUP. But how current do you need the data? Typically, you can survive with it being a bit behind. I wouldn't think you'd want to do it every night.Tara |
 |
|
|
|
|
|
Maintain Test database updated