Daily restore SQL DB to test

joka2

Newcomer
Joined
Aug 8, 2012
Messages
4
Reaction score
0
Points
0
PREDATAR Control23

Hi,

We need to refresh one of our test SQL every day with current state of the prod DB. I guess Im not the only one who wants to do this.

Using tdpsqlc would that be possible?

Im dealing with two challenges:

1) using /restoredate option - how can I tell the script to restore one day behind? /restoredate=today-1 does not work. Another option would be to have tdpsqlc restore the most current Full + Diff + log in one command (how?)

2) The database is quite big to be doing a daily Full restore on it (800GB). In our system that takes about 5 hours. Would it be possible to incrementally restore the database? That is: once a week, restore full with recovery=yes and the day after only restore diff? The problem here is since I do recovery=yes for the first full restore, I don't see that I'm going to be able to restore the diff next day.
 
Top