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.
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.