How to restore backup from one server SERERA to another server SERVERB.
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 :-)