I have daily maintenance schedule backup(A,B,C,D databases) on my SERVER A. I want to restore that backup on my production server i;e SERVER B automatically or using scheduller or any other maintenance plan.
Both Servers are using SQL SERVER 2008 R2.
How I achieve? i have seen lot of article but no one having fruitfull.
Thanks,
Mangesh :-)
Loading
Sukesh MarlaPosted Sep 1, 2012, 6:17 AM
Use Bi technologies like SSIS and SSAS.
Chcek this is correct answer if it helped