wannalearn (12/26/2012)
In our office we run jobs to keep these environment in sync. We get data from outside source and run the job overnight to load data on Prod. It's not a big environment so we have managed to do back up and restore on other environment as per need basis.I am assigned to find out better way to keep them in sync. I have googled on this topic and I am lost right now.
Plz advise.
The best way is Logshipping depends on the daily load though...
If it is huge load every day then go for creating a SSIS package to refresh teh dB in test and other region using Auto sql job.